Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29520 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
Is INSTEAD OF trigger directly applicable to Table ?
how would you troubleshoot blocking? : Sql server database administration
Define tempdb database?
What are distributed partitioned views?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Where are SQL server users names and passwords are stored in sql server?
What is the osql utility?
What are the ways available in sql server to execute sql statements?
Tell me what do we need queues in sql service broker?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is a non-clustered index?
What is the difference between count () and rowcount ()?
What triggers long term care?
