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 can change procedure in sql server?
What are the differences between triggers and stored procedures?
What is the downside of using udf?
Detail about query optimizer?
Explain what is meant by replication of database?
How to rename databases in ms sql server?
Define full outer join in sql server joins?
What is key attribute?
Where to find ntwdblib.dll version 2000.80.194.0?
Define candidate key, alternate key, and composite key.
What is Schema? and why we use schemas?
What are the different types of replication? How are they used?
Oracle (3253)
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)