select max(empno) from dbo.Employee having count(EmpNo)=9 it has no mean

Can Having clause be used without Group by clause?

Question Posted / pradip jain

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How does using a separate hard drive for several database objects improves performance right away?

990

What are the options which must be set to allow the usage of optimistic models?

1020

State the difference between union and union all?

987

What is a trace frag?

1136

How to create a trigger for insert only?

1087

What is the parse query button used for?

1089

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1170

What are entities and relationships?

1025

Can sql servers link to other servers like oracle?

896

How to execute function in stored procedure sql server?

1236

How to create view in stored procedure sql server?

1057

Which are the new data types introduced in sql server 2008?

931

Is ssrs support other database except ms sql server?

142

What is the report builder?

143

What is delete query?

993