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 to create a scrollable cursor with the scroll option?

1004

What is a subquery in a select query statement in ms sql server?

1135

How you can get a list of all the table constraints in a database?

958

Which language rdl files made of?

130

When would you use it?

1001

Explain difference between control flow and data flow?

970

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1055

What is stored in the mssqlsystemresource database? : sql server database administration

1035

What is 4nf in normalization form?

1030

Is it possible to have clustered index on separate drive from original table location?

969

Why do you need a sql server?

1115

What is recompile sql server?

1045

how can you check the level of fragmentation on a table? : Sql server administration

987

How do you know if sql server is running on your local system?

1045

What is oltp (online transaction processing)?

1015