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

Answer Posted / vinay singh

Select * From Employee
Where Salary in
(Select Salary From Employee Group by Salary Having
Count(Salary ) > 1)

**Vinay Singh
**9867774724

Is This Answer Correct ?    45 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the parse query button used for?

608


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

571


What are different types of roles provided by ssrs?

112


What is a coalesce function?

669


how to use DTS package in 2000,2005,2008 in sql server

1457






How to create percentile function?

108


What is a covering index?

536


Does partitioning improve performance?

493


Using the customer, and order table in northwind database, please write a query to produce xml?

657


What are data files?

583


What is the difference between mysql and mysqli?

585


What is the purpose of sql profiler in sql server? : sql server database administration

630


How to create function without parameter in sql server?

563


How to create a simple stored procedure in ms sql server?

523


How adventureworkslt tables are related?

533