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 do you run a trace?
What are types of scd? : sql server analysis services, ssas
explain different types of jions with examples briefly?
What is simple indexing method?
What are the benefits of normalization?
How to convert numeric expression data types by assignment operations?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Name three version of sql server 2000 and also their differences?
What are the different normalization forms?
How to get the count of distinct records. Please give me the query?
What are sql server functions?
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)