What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26384 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the need for indexing?
How to perform key word search in tables?
what information is maintained within the msdb database? : Sql server administration
What are parameterized reports?
What is the data tier application?
How to integrate the ssrs reports in application?
How to recompile stored procedure at run time?
What is the use of builtinadministrators group in sql server? : sql server security
What is the difference between set and select?
What are the requirements on sql server network connections?
What are the restraints imposed on the table design by a merge replication?
Does group by or order by come first?
What do you understand by a view?
How to retrieve error messages using mssql_get_last_message()?
How to generate create procedure script on an existing stored procedure?
