Can Having clause be used without Group by clause?
Answer Posted / 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 |
Post New Answer View All Answers
Why do we use stored procedures in sql server?
Can we use pragma autonomous_transaction in trigger?
what is spatial nonclustered index
How to delete an existing row with delete statements in ms sql server?
What is 1nf 2nf?
List out a number of the wants to setup a SQL Server failover cluster?
Explain different types of locks in sql server.
How do I edit a stored procedure in sql server?
What is Cross Join and in which scenario do we use Cross Join?
Which are new data types introduced in sql server 2008?
What are the differences between ms sql server & oracle?
How to delete duplicate rows from table except one?
What are the types of sql server?
What is the use of RDBMS?
What are relationships and mention different types of relationships in the dbms