what is difference between having and where clause ?
Answer Posted / raju
Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a collation in ms sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
How to generate create view script on an existing view?
What is data source view or dsv? : sql server analysis services, ssas
Explain syntax for viewing, dropping and disabling triggers?
What is default constraint?
What is the size of transaction log file?
Distinguish between nested subquery and correlated subquery?
What command is used to create a database in the sql server and how?
what is a mixed extent? : Sql server administration
What is serializable?
what protocol both networks use? : Sql server database administration
How to run sql server 2005 books online on your local system?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is update locks?