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

Explain about integration services of Microsoft SQL server?

1082

Explain the flow of creating a cube? : sql server analysis services, ssas

1098

Define tempdb database?

1038

What is index fragmentation in ms sql server?

1139

Define Business Edition in SQL Azure?

102

Can sql server 2016 run on windows 7?

963

Why are you getting errors when creating a new odbc dsn?

1285

What is sql server schema compare? How we can compare two database schemas?

1077

What are the 2 types of classifications of constraints in the sql server?

1180

What is the tcp/ip port on which sql server runs?

1234

How to create new table with "create table" statements?

1191

Name the different type of indexes in sql?

1012

Explain about local stored procedure?

1027

How many cores do I need for sql server 2016?

950

What is server-level principal?

122