What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
List down some advantages of sql stored procedure?
Which sql server table is used to hold the stored procedure scripts?
Explain what is raid and what are different types of raid levels?
What is use of @@ spid in sql server?
How raid can influence database performance?
Explain “@@rowcount” and “@@error” in sql server?
What is shrink log file?
Mention what are the core components of ssrs?
How to convert numeric expression data types using the cast() function?
How to find Duplicate Records In table?
How can you find out which stored procedures are recompiling?
What is the difference between getdate and sysdatetime?
How to view the error log for any specific instance? : sql server database administration
What is entity data services?
Mention the uses of stored procedures.