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 a database and a data warehouse?

571

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

508

What is difference between index seek vs. Index scan?

626

Find columns used in stored procedure?

529

How to sort the query output with order by clauses in ms sql server?

636

what are the reporting service components in SSRS?

118

What is open database communication (odbc)?

573

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

534

Explain in brief about Microsoft SQL server?

547

What is ddl command?

535

How to include date and time values in sql statements?

630

How to receive output values from stored procedures?

483

What does set rowcount do?

514

Difference between 2NF &3NF ?

683

How can I check that whether automatic statistic update is enabled or not?

557