select * from emp where emp=(select sal from emp group by sal having coun

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Question Posted / gangi naidu.k

Answer Posted / gangi naidu.k

select * from emp where emp=(select sal from emp group by
sal having count(sal)>1)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me in brief how sql server enhances scalability of the database system?

536

What is cdc in sql server?

574

How to execute a sql statement using odbc_exec()?

574

Why do we use non clustered index?

555

How do I save a stored procedure in sql server?

497

What is tablix?

115

List the different index configurations possible for a table?

516

How to send a ssrs report from ssis?

125

How to define output parameters in stored procedures?

527

Write a sql query to get zero records from a table having n number of records?

711

What is use of attributehierarchyenabled? : sql server analysis services, ssas

615

Explain what are the events recorded in a transaction log?

558

What is BCP? When does it used in sql server 2012?

582

Explain sub-query?

571

What is temporal data type?

525