Can Having clause be used without Group by clause?
- 6 Answers
- 41614 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
Why are you getting errors when creating a new odbc dsn?
Is sql server difficult to learn?
What is difference between group by and having?
Do you know exporting and importing utility?
What is difference between drop truncate and delete?
What is the purpose of sql profiler in sql server? : sql server database administration
Do you know concepts and capabilities of sql server?
What is an example of a primary key?
Differentiate between mongodb vs. Sql server?
What are trace files?
What is the difference between a view and a stored procedure?
how we use window authentication connection with sql server.?
What are distinctive joins find as a part of sql?
Is candidate a key?
Explain the properties of sub-query in sql server?
