HAVING Clause

Given a SELECT statement that has a GROUP BY clause.
The HAVING clause uses the same syntax as which other clause?
A. WHERE
B. UNION
C. SUBQUERY
D. ORDER BY

Questions by madhulatha_madduri   answers by madhulatha_madduri

Showing Answers 1 - 7 of 7 Answers

toton_tcs

  • Mar 2nd, 2010
 

HAVING clause is just to project the groups which are to be displayed in the output table and it should be written just below the GROUP BY phrase.

  Was this answer useful?  Yes

Ksudhir_Kumar

  • Sep 5th, 2010
 

Having clause is used filter data which is retrieve by group by clause.
for example: if
you try to use having to filter data instead of where clause then it fires error.
the style of query is:-

1.
Select from
2. Where clause
3.
Group by
4. Having
5. Order by

It is better to use order by at last of the query.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions