Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5723 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 |
How to convert a unicode strings to non-unicode strings?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
Explain the use of keyword with encryption. Create a store procedure with encryption?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What happens if the update subquery returns multiple rows in ms sql server?
What's the difference between a primary key and a unique key?
What is ms sql server index?
What are the steps you should follow to start sql server in single-user mode?
What is pessimistic concurrency?
Explain fundamentals of Data ware housing & OLAP?
How many types of triggers are there?
What is dirty read?
-
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)
