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
How to change the system date and time from SQL Plus Terminal ?
Explain about link server in sql server?
What is the difference between update lock and exclusive lock?
What are the new scripting capabilities of ssms? : sql server management studio
What is check constraint in sql server?
Explain how dts is used to extract, transform and consolidate data?
What is a scheduled job or what is a scheduled task?
If a table does not have a unique index, can a cursor be opened on it?
Explain the Ways to improve the performance of a sql azure database?
What is command parameter in ssrs?
How is a full-text index updated?
How network traffic be reduced by using the stored procedure?
Define inner join? Explain with an example?
How can I create a report based on a query? : sql server management studio
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture