The HAVING clause does which of the following?
- Acts like a WHERE clause but is used for groups rather than rows
- Acts like a WHERE clause but is used for columns rather than groups
- Acts EXACTLY like a WHERE clause
- Acts like a clause but is used for rows rather than columns
Explanation
- The HAVING clause is used in SQL to filter groups of rows based on a condition, similar to how the WHERE clause filters individual rows.
- The HAVING clause is applied after the GROUP BY clause, which groups the rows into sets, whereas the WHERE clause is applied before the GROUP BY clause.
Related MCQs
متعلقہ ڈیٹا کے مجموعے کو کیا کہا جاتا ہے؟
- Database
- Software
- Hardware
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
ای میل کس مقصد کے لیے استعمال ہوتی ہے؟
- Sending electronic messages
- Browsing websites
- Editing images
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
ایل اے این کا مطلب کیا ہے؟
- Limited Area Network
- Logical Area Network
- Local Area Network
- Large Area Network
اس سوال کو وضاحت کے ساتھ پڑھیں
آئی بی ایم کس کا مخفف ہے؟
- International Business Machine
- Integrated Business Machine
- Information Business Machines
- International Business Model
- None of the above
اس سوال کو وضاحت کے ساتھ پڑھیں
بی سی سی کا مطلب کیا ہے؟
- Basic Carbon Copy
- Blind Carbon Copy
- Business Carbon Copy
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
