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

What are differences in between sql server 2012 and sql server 2016?

972

What is the significance of master, tempdb and model databases?

1020

What is the new security features added in sql server 2016? : sql server security

1054

What are the new security features added in sql server 2012? : sql server security

944

What is merge replication?

1064

What types of replication are supported in sql server?

995

what is memory-optimized nonclustered indexes

955

Can a cursor be updated? If yes, how you can protect which columns are updated?

1027

Mention the differences between substr and charindex in sql server.

982

What is a mutating table error and how can you get around it?

962

What is the purpose of linked server configuration in sql server?

982

Difference between connected and disconnected database in .net with sql server?

1031

Can we insert data into a view?

1061

What is cursor in ms sql server?

1083

What is use of @@ spid in sql server?

1143