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 the types of resultset?

915

why would you call update statistics? : Sql server database administration

1011

Can you explain important index characteristics?

938

What is acid mean in sql server?

1036

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

986

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1156

How does clustered and non clustered index work?

849

What are the differences between triggers and stored procedures?

990

Explain about thread and memory management process of SQL?

923

Differentiate between sql temp table vs table variable?

830

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

976

What is bcp? When does it used?

921

What is abstracting periodical?

896

What is "scheduled jobs" or "scheduled tasks"?

912

What is merge?

933