Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43586 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
Define Joins?
What is exporting utility?
Explain transaction server distributed transaction?
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the essential components of sql server service broker?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Why should one not prefix user stored procedures with ‘sp_’?
What is built-in function?
Explain view in sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are different types of raid levels?
What is the name of the Database which IBM mainframe uses?
How to apply cascading referential integrity in place of triggers?
What is plan freezing?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
