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
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is the query and subquery?
What do you mean by an execution plan?
Define compound operators?
Define ACID properties in a Database?
System variable and temporary variables
Why use “pivot” in sql server?
What are scalar functions in sql?
What are the approximate numeric data types?
What is a trace frag?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
List the different types of joins?
Is there any difference between primary key and unique with the not null condition?
How to verify a login name with sqlcmd tool?
Explain the dbcc pintable command when would you use it?