Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43612 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / shailesh yadav
Yes HAVING caluse can be use without GROUP BY. the SQL HAVING clause is often used with the GROUP BY clause. If the GROUP BY clause is omitted, the MySQL HAVING clause behaves like the WHERE clause. Notice that the MySQL HAVING clause applies the condition to each group of rows, while the WHERE clause applies the condition to each individual row.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the limitations in ssrs on sql server express edition?
What is the difference between createstatement and preparedstatement?
What is the language structure to add a record to a table?
What are the different types of sql server replication? : sql server replication
What is sql server profiler trace data file?
Equi join and non equi join is possible with sql server?
Explain the xml support sql server extends?
How to remove duplicate rows from table?
What is a full text index?
What is the order in which the sql query is executed?
What is auditing in sql server?
What is BCP? When does it used in sql server 2012?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is best institute to Learn DotNET And SQL in chennai?
What is store procedure? How do they work?
