Can Having clause be used without Group by clause?
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 happens if strings are casted into wrong code pages in ms sql server?
How to set database to be single_user in ms sql server?
What are the built in functions in sql server?
What are constraints in microsoft sql server?
What are ddl (data definition language) statements for tables in ms sql server?
How to modify an existing user defined function?
What's new in sql management studio for sql server? : sql server management studio
How to test subquery results with the exists operator?
What does select 1 mean?
Explain can you implement data mining in ssrs?
What is the process of normalization?
What structure can you implement for the database to speed up table reads?
How do I find the sql server version?
How to insert stored procedure result into temporary table?
How to drop existing views from a database in ms sql server?