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
How to delete duplicate rows from table except one?
How many types of database relationship in sql server?
How to create prepared statements using odbc_prepare()?
Explain how many normalization forms?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to rename an existing column with sql server management studio?
What is reference section?
What are sql server procedures?
What is a non-clustered index?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the function of sql server agent windows service?
What is the contrast amongst drop and truncate?
What are triggers in ms sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?