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 is SQL Azure Federations?

Explain the use of keyword with encryption. Create a store procedure with encryption?

541

How to view the error log for any specific instance? : sql server database administration

583

What is the query and subquery?

626

How to override dml statements with triggers?

583

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

543

Can I run multiple instances of sql server 2000 at the same time on one computer?

609

How can we rewrite sub-queries into simple select statements or with joins?

528

Can another user execute your local temporary stored procedures?

547

What are the new scripting capabilities of ssms? : sql server management studio

559

What triggers long term care?

565

What is a database in ms sql server?

554

How to identify current user in ssrs report?

242

How to get the definition of a user defined function back?

571

How to create new databases with "create database" statements?

570