Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raju
Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / dhiman
Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anil sharma
Having clause ia used only with group by, and where used with any input type
| Is This Answer Correct ? | 0 Yes | 3 No |
Where to find ntwdblib.dll version 2000.80.194.0?
What is join and name different type of joins?
What are the triggers in sql?
What are the components of dbms?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is the difference between rank and dense_rank?
How to stop log file growing too big?
What are the 10 characteristics of data quality?
Difference between server.transfer and server.execute method?
Differnce between sel server 2000 and 2005
What is 2nf example?
can a database be shrunk with users active? : Sql server administration
-
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)
