Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29684 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 |
How can we get count of the number of records in a table?
What is row_number function?
Why is the need for data conversion transformations?
What is a join in sql? What are the types of joins?
Is truncate autocommit?
What the class forname () does?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is the primary use of the model database?
What is the fastest way to permanently delete a 1 million row table named customers?
What is difference between views and tables?
What is the dbcc command and why is it used?
What is a trigger and types of a trigger?
-
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)
