Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43338 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
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is oltp (online transaction processing)?
What are the security related catalog views? : sql server security
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is the difference between a stored procedure and a user defined function?
How many triggers you can have on a table?
Explain “row_number()” in sql server with an example?
What are the acid properties?
What is the latest version of microsoft sql server?
What are the types of database schema? : sql server analysis services, ssas
What is the cpu pressure?
Can I work with several databases simultaneously? : sql server management studio
How can you append an identity column to a temporary table?
What is mean by candidate key?
What are the differences between ms sql server & oracle?
