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 is a dynamic query?

1027

What are the different types of sql commands?

1128

How do I count rows in sql query?

995

What is trigger in pl sql?

1004

Can we commit in trigger?

978

Is the primary key an index?

1026

Is sql microsoft?

1058

how to drop an existing view in mysql? : Sql dba

1062

What is trigger and how to use it in sql?

1021

what is a constraint? Tell me about its various levels. : Sql dba

988

Can instead of triggers be used to fire once for each statement on a view?

962

What is sql prepared statement?

989

Can we insert in view in sql?

1065

How do you rank data in sql?

1009

I need a function for a train ticket reservation please answer it thanks in advance

1028