we can use, but select columns and having columns should use with aggrega

Can Having clause be used without Group by clause?

Question Posted / phani

6 Answers
43332 Views
CarrizalSoft Technologies, CSC, CTS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is auditing in sql server?

928

How to change server name in sql server?

1185

Explain what is row_number function?

1040

Is mysql the same as sql server?

989

Does table partitioning improve performance?

972

What is ms sql server index?

1108

Explain database normalization?

1229

What is save transaction and save point?

1202

Show Practically Sql Server Views are updatable?

1124

What's new in sql management studio for sql server? : sql server management studio

1066

How to change the system date and time from SQL Plus Terminal ?

1222

Explain what is cte (common table expression)?

1132

What are orphan records?

932

What are the events recorded in a transaction log?

1000

what is spatial nonclustered index

992