What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to locate and take substrings with charindex() and substring() functions?
What are the steps you can take to avoid “deadlocks”?
What stored by the model?
What are the different types of collation sensitivity in sql server?
Define model database?
Define views.
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain how to integrate the ssrs reports in application?
What is difference between sql and sql server?
What is coalesce and check constraint in sql server?
What is a rollup clause?
What is acid db?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are the triggers in sql?
What is precedence constraint?