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

Answer Posted / vidyalakshmi.s

select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is truncate table?

525


How do you trace the traffic hitting a sql server?

592


Name three of the features managed by the surface area configuration tool? : sql server security

489


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

523


How do I create an extended event in sql server?

466






What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

570


Can group by be used without aggregate functions?

448


How will you make an attribute not process? : sql server analysis services, ssas

555


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

531


What do you need to connect php to sql server?

514


If a stored procedure is taking a table data type, how it looks?

5766


What is the use of set nocount on/off statement?

603


What is sql server profiler?

542


What is application role in sql server database security? : sql server security

526


What is store procedure? How do they work?

558