What is the difference between having and where clause?
Answer Posted / kundan ravi
having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are different types of table joins?
Can a synonym name of a table be used instead of a table name in a select statement?
What do you mean by data manipulation language?
How important do you consider cursors or while loops for a transactional database?
How to fine-tune reports?
What is the purpose of indexing?
What are wait types?
Who developed sql server?
List all types of constraints in sql server?
Do you know how to store and query spatial data?
What is GUID in sql server?
What is trace flag in sql server?
what is the difference between Delete and Truncate command in SQL
How to truncate the log in sql server 2012? : sql server database administration
What is the impact on other user sessions when creating indexes?