Can Having clause be used without Group by clause?
Answers were Sorted based on User's Feedback
Answer / phani
we can use, but select columns and having columns should
use with aggregare functions
ex:
select max(empid), min(marks)
from employee
having max(empid_id)>100
Is This Answer Correct ? | 72 Yes | 16 No |
Answer / debasish
we can use having clause without group bu clause .but it
will act as where clause
Is This Answer Correct ? | 68 Yes | 33 No |
Answer / sumathy
HAVING Clause
Specifies a search condition for a group or an aggregate.
HAVING is usually used with the GROUP BY clause. When GROUP
BY is not used, HAVING behaves like a WHERE clause.
Reference:
http://msdn.microsoft.com/en-us/library/aa259187
(SQL.80).aspx
Is This Answer Correct ? | 30 Yes | 3 No |
Answer / pradip jain
select max(empno) from dbo.Employee having count(EmpNo)=9
it has no meaning so it will show zero record
Is This Answer Correct ? | 17 Yes | 6 No |
Answer / 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 |
Answer / anilreddy
No,we can not use.If there is Having it must followed by Group By
Is This Answer Correct ? | 6 Yes | 52 No |
Can you explain the role of each service?
What do you understand by coalesce in sql server?
What are the steps you will take to improve performance of a poor performing query?
Can Somebody tell me the difference between Clustered & Non- Clustered Index??
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is the difference between local and global temporary tables?
how to implement locking in sql server
What are xml indexes?
How can you ensure that the database and sql server based application perform well?
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;
how to give input dynamically to a insert statement in sqlserver
what is unique and xaml nonclustered index