what is difference between having and where clause ?
- 3 Answers
- 4972 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 |
Explain the benefits of user-defined functions?
What is nonclustered index on computed columns?
How to send email from database?
What is subquery? Explain the properties of a subquery?
What is log shipping?
How to provide values to stored procedure parameters in ms sql server?
 Explain what is sql override for a source taLle in a mapping?
How to get the definition of a user defined function back?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How do I start and stop sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What are system databases into sql server (2005/2008)?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
