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 copy the tables, schema and views from one sql server to another?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Explain contrast amongst grouped and non-bunched records?
What is a subquery in a select query statement in ms sql server?
What is buffer cash in sql server?
What is data compression? : sql server database administration
How can you start sql server in different modes?
What is the language structure to add a record to a table?
List some major differences between triggers and stored procedures?
How to execute a sql statement using mssql_query()?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is DCL?
What happens if null values are involved in string operations?
what changed between the previous version of sql server and the current version? : Sql server database administration
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?