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
43369 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 do you understand by sql server agent?

987

Explain ms sql server reporting services vs crystal reports?

931

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

972

What is the difference between coalesce() & isnull()?

1147

Relational calculus is what type of language?

1048

Why Master database is required?

1150

When to use null data driven subscription?

209

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2098

What are the rendering extensions of ssrs?

160

What are different types of roles provided by ssrs?

154

What is the difference between migration and upgradation in sql server?

1106

What is bulkcopy in sql?

953

Define magic tables in sql server?

1072

How do I view a stored procedure in sql server?

988

Which language is supported by sql server?

1022