Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5836 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 |
What is buffer cash and log cache in sql server?
What are sparse columns?
Explain the working of sql privileges?
What is temporary stored procedure?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What are acid properties of transaction?
can you any body tell me suppose database is suspect mode. how can take to normal?
How to handle errors in Stored Procedures.
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
Is it possible in sql table to have more than one foreign key?
Define right outer join in sql server joins?
What is an execution plan? When would you use it?
-
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)
