What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30201 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why we use the openxml clause?
What are the different SQL Server Versions you have worked on?
Is it possible to have clustered index on separate drive from original table location?
What is sql server query analyzer?
Explain system functions or built-in functions? What are different types of system functions?
How to convert character strings into numeric values?
What is an indexed view?
How raid can influence database performance?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the properties of the transaction?
What is self contained sub query?
What is a view in sql?
What is the primary use of the model database?
How to connect php with different port numbers?
How to enter binary string literals in ms sql server?
