where clause filter the data before gruop by clause and having clause cla

what is Difference between Having and Where clause?

Question Posted / nrapendra

Answer Posted / nrapendra

where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1033

What is asqueryable?

903

What are the parts of a basic sql query?

918

What are different functions in sql?

897

What is an emotional trigger?

930

What is crud stand for?

931

What are the features of pl sql?

1013

Is record in oracle pl sql?

902

Can we join more than 2 tables in sql?

946

Difference between global and parameter variables?

1906

what are all the common sql function? : Sql dba

1010

Is a secondary key the same as a foreign key?

953

What are the parts of a sql statement?

1028

What is normalization in a database?

1105

can sql servers linked to other servers like oracle? : Sql dba

953