What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26988 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aravind
where is used when no group by functions are used whereas
having is used when group functions are used
| Is This Answer Correct ? | 3 Yes | 11 No |
what stored procedure can you use to display the current processes? : Sql server administration
Where are magic tables stored ? Is it in the same database where it is created ?
What is primary key and example?
Does transparent data encryption provide encryption when transmitting data across the network?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How to Rebuild Master database in sql server 2005.
How you provide security to cube? : sql server analysis services, ssas
What is the difference between views and stored procedures? Can we have input parameters for views?
write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car
What are the diifferences between the ms sql server vs mysql?
How to Get the last identity value used
How cand Optimize SQL Server Stored Procedures
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
