HAVING clause is used only with GROUP functions whereas WHERE clause we c

what is difference between where clause and having clause?

Question Posted / pawan

Answer Posted / pawan

HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.

Is This Answer Correct ?

8 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What happens if the imported table already exists?

1019

What is procedure overloading in oracle?

1032

Name the various constraints used in oracle?

1001

What are the oracle built-in data types?

1043

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3184

What is recycle bin in Oracle?

1132

How to define an oracle cursor variable?

1009

what is Single Byte Overhead...?

2537

What is the difference between view and materialized view in Oracle?

1126

is there a tool to trace queries, like profiler for sql server?

1130

How to download oracle database 10g xe?

1004

Can we insert data in view oracle?

998

What are the advantages of oracle 12c?

1163

How would you go about verifying the network name that the local_listener is currently using?

2027

List out the difference between commit, rollback, and savepoint?

1018