Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus

This question is related to Oracle Interview
  • Interview Candidate
  • 7
  • 5754

Showing Answers 1 - 7 of 7 Answers

kranti

  • Jul 28th, 2005
 

having

  Was this answer useful?  Yes

Divakala

  • Nov 22nd, 2005
 

kranti Wrote: having

Hi,

Having clause is used to apply some condition on the data that is retrieved by using Group by and select from that.

sree

  Was this answer useful?  Yes

sandeep

  • Nov 7th, 2006
 

where is correct

  Was this answer useful?  Yes

sindhu

  • Aug 29th, 2007
 

When "having, groupby, where" are present in the same statement, the order of execution is
1. Where
2. Group By
3. Having

  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