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

How to start and end transact-sql statements?

1085

What language is sql server written in?

1079

How can windows applications connect to sql servers via odbc?

1177

What are the limitations/drawbacks or ssrs 2008 r2?

152

Which table keeps the locking information?

984

How to delete existing triggers using "drop trigger"?

1097

Explain error handling in ssis?

1070

What is difference between rownum and rowid?

956

Why use sub query in sql server and list out types of sub queries?

1055

What are the advantages of sql azure?

140

How many levels of sp nesting is possible?

1099

Explain the phases a transaction has to undergo?

1111

How to execute a sql statement using mssql_query()?

1104

Explain about the command-line tool SQLCMD?

1144

How to make remote connection in database?

1049