Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5572 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 onf in normalization form?
Why truncate is ddl?
What are the instances when triggers are appropriate?
What is rolap and its advantage? : sql server analysis services, ssas
What is sub-query in sql server? Explain its properties.
How will you decide the active and passive nodes?
What do you mean by tablesample?
What is field in algebra?
What is data compression? : sql server database administration
Explain the use of containers in ssis?
Give me a SQL Query to find out the second largest company?
What is the difference between Stored Procedures and triggers?
-
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)
