What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / senthil kumar t
Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
How to create indexed view?
What is the architecture of ms sql reporting service?
What is clustered primary key?
How many triggers you can have on a table?
please differentiate between delete and truncate?
How data can be copied from one table to another table?
What does the update command do?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is the full form of dql?
Explain what is raid and what are different types of raid levels?
Why olap is used?
Describe the functionalities that views support.
How to turn off warning messages during php execution?
What stored procedure would you use to view lock information?