When we used group by that time only we can use having. But without group b

what is Difference between Having and Where clause?

Question Posted / joe

Answer Posted / joe

When we used group by that time only we can use having. But without group by we can use having.
Only grouped column have used in having condition

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the types of optimization?

887

What is sql query optimization?

1021

Can pl sql procedure have a return statement?

959

How can we make an if statement within a select statement?

957

What is a heap in sql?

991

How do I run a sql trace?

905

What does subquery mean in sql?

988

What is the best sql course?

930

What is sql performance tuning?

866

what is online transaction processing (oltp)? : Sql dba

935

What is trigger in flip flop?

957

Does view store data in sql?

901

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1092

What is the difference between union and union all command?

1007

What is the usage of sql functions?

1077