Where clause is used to restrict rows but having clause is used to restri

what is difference between where clause and having clause?

Question Posted / narender sharma

Answer Posted / narender sharma

Where clause is used to restrict rows but having clause is
used to restrict groups

Is This Answer Correct ?

28 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is flashback in Oracle?

1063

What privilege is needed for a user to insert rows to tables in another schema?

1057

Explain the use of grant option in imp command.

1079

What are data pump export and import modes?

1111

What is dual table oracle?

1029

What is the difference between postgresql and oracle?

1105

How to resolve the ORA-39133 error in Oracle?

1184

How to revoke create session privilege from a user in oracle?

1068

How to get a create statement for an existing table?

1014

What is the difference between hot backup and cold backup in oracle?

1078

How to create tables for odbc connection testing?

1206

What is the difference between a hot backup and a cold backup in oracle?

1076

How to convert a string to a date in oracle database?

1100

Which is better Oracle or MS SQL? Why?

6484

What is difference between cartesian join and cross join?

1157