Having clause is used for filtering grouped data and where clause is used

what is Difference between Having and Where clause?

Question Posted / chandrakala

Answer Posted / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Is This Answer Correct ?

33 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can you get sql*loader to commit only at the end of the load file? : aql loader

965

Is it possible to include an insert statement on the same table to which the trigger is assigned?

956

What is pragma in pl sql?

1020

How to find 3rd highest salary of an employee from the employee table in sql?

1035

Define a temp table?

965

what are the differences between char and nchar? : Sql dba

1055

Why is sharding used?

940

In pl/sql, what is bulk binding, and when/how would it help performance?

937

Which join condition can be specified using on clause?

899

What is on delete set null?

1037

What is scope and visibility in PL/SQL?

1114

What is delimiter sql?

921

What is a primary key? Explain

920

What is server name sql?

1068

How many types of indexes are there in sql?

933