What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Post New Answer View All Answers
Write query to return all rows sql?
How can we delete a table in sql server?
What is the simplest way to create a new database in ms sql server?
Is a primary key unique?
What is a derived table?
What are database states in ms sql server?
What is model database in sql server?
Name 3 ways to get an accurate count of the number of records in a table?
Difference between Inner vs outer joins?
when you create a database how is it stored? : Sql server database administration
How you can get a list of all the table constraints in a database? : Sql server administration
What are data files?
What is page in sql server?
Explain filtered indexes?
can an order by clause be used in a creation of a view?