what is Difference between Having and Where clause?
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 |
Post New Answer View All Answers
Explain the difference between triggers and constraints?
Does truncate require commit?
What is Materialized View? In What Scenario we Use Materialized View?
What do you mean by stored procedures? How do we use it?
What is the primary use of normalization?
Explain what is a column in a table?
What are database links used for?
How many sql core licenses do I need?
What is the sql query to display the current date?
What does truncate mean in sql?
how to select unique records from a table? : Sql dba
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is the difference between distinct and unique in sql?
What is mdb stand for?
Why indexing is needed?