What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 27000 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / aravind
where is used when no group by functions are used whereas
having is used when group functions are used
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Define outer join?
What do you know about normalization and de- normalization?
What are various limitations of the views?
What are the restrictions that views have to follow? : SQL Server Architecture
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Would you store your query in a ssrs report or a database server? State the reason why?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is user defined stored procedures?
Explain the concept of recursive stored procedure.
What do you understand by replication in sql server?
explain declarative management framework (dmf) in sql server 2008?
How to restore performance issues and how to check?
What are unicode character string data types in ms sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is not null constraint?
