What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26292 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is difference between views and tables?
How to add additional conditions in SQL?
How many databases can we create in a single server?
What does select 1 mean?
What do you understand by the denormalisation?
What are the steps to insert a table?
Explain what is scheduled job and how to create it?
In what three ways is the return statement used in a stored procedure?
What are diverse clauses that form a part of sql?
What are the differences between union, intersect, and minus operators?
What is transaction server auto commit?
How do you troubleshoot errors in a SQL Server Agent Job?
What is a view and what are its advantages?
Why do we partition data?
