Can Having clause be used without Group by clause?
- 6 Answers
- 40113 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 kind of lan types do you know? : Sql server database administration
Do you know how to store and query spatial data?
What is the default port for SQL Server over a firewall?
What is update_statistics command?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain go command in sql server?
How to convert binary strings into integers in ms sql server?
What is server-level principal?
Explain filtered indexes benefits?
What do you mean by recursive stored procedure?
Explain what is public role in sql server?
Tell me what is log shipping?
Can you please explain the difference between function and stored procedure?
What is tcl in sql server?
What command would you use to add a column to a table in sql server?
