Discussion :: Introduction to SQL - General Questions (Q.No.27)
To sort the results of a query use:
Answer: Option C
No answer description available for this question.
|Rabindra said: (Apr 7, 2017)|
|Why we use GROUP BY in SQL?
Describe in detail.
|Shubham said: (Aug 10, 2017)|
|GROUP BY in SQL is used to apply conditions on the columns.
For example, if you want to find the numbers of Names which are occurring more than 100 times in a Name column of the Student table, then condition must be applied on the column.
SELECT ID, Name
GROUP BY (Name)
HAVING count(Name) >= 100;
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.