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
ایک مرتب کیا ہے؟
- A compiler is a special program that processes statements written in a particular programming language and turns them into machine language
- A compiler is a language providing very efficient execution
- A compiler does a conversion line by line as the program is run
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
درج ذیل میں سے کون سا اینڈرائیڈ کے آفیشل ورژن کا کوڈ نام نہیں ہے؟
- Muffin
- Cupcake
- Donut
- Lollipop
اس سوال کو وضاحت کے ساتھ پڑھیں
کسی ویب سائٹ کو صارف کی شناخت یاد رکھنے میں کون سی چیز مدد دیتی ہے؟
- Cookies
- Firewall
- Cache
- Compiler
اس سوال کو وضاحت کے ساتھ پڑھیں
جب صارف کمپیوٹر آن کرتا ہے تو آپریٹنگ سسٹم شروع کرنے کے عمل کو کیا کہا جاتا ہے؟
- Starting
- Loading
- Booting
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
کمپیوٹر سسٹم میں بوٹ کا لفظ استعمال ہوتا ہے؟
- To exit opened software
- To start up a software
- To shutdown system
- To start a computer
اس سوال کو وضاحت کے ساتھ پڑھیں
