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
How can I change database name in sql?
Does sql full backup truncate logs?
Is t sql a programming language?
What is the difference between having and a where in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
Can you skip header records while loading? : aql loader
What is composite primary key in sql?
Show how functions and procedures are called in a pl/sql block.
What is clause in sql?
How to return multiple rows from the stored procedure?
What are the three pl sql block types?
Why truncate is faster than delete?
What is an emotional trigger?
How does pl sql work?
What is aggregate function in sql?