What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answers were Sorted based on User's Feedback
Answer / aravind
where is used when no group by functions are used whereas
having is used when group functions are used
| Is This Answer Correct ? | 3 Yes | 11 No |
How many databases Microsoft SQL server provides?
What is the difference between SSAS 2000 and SSAS 2005?
What is the difference between migration and upgradation in sql server?
what are the advanced features in sql 2008?
How to integrate the ssrs reports in application?
What is merge join?
wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......
what is normalization? : Sql server database administration
Define views.
What are the two types of concurrency?
What are views in ms sql server?
What is difference between count (*) and count 1?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)