What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26293 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
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 to find out what is the default collation in a database?
Can you please explain the difference between function and stored procedure?
What is the use of sign function?
What is an indice?
How create table structure only from tableA to TableB if TableA have some data?
what is a schema in sql server 2005? : Sql server database administration
What is merge join?
Why is normalisation important?
Suggest a method of joining two tables.
0 Answers Ernst Young, Thomson Reuters,
What do I need to start working with sql studio? : sql server management studio
What is not null constraint?
Why de-normalization required?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
