Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Where sql server user names and passwords are stored in sql server? : sql server database administration

1034


Explain the different types of joins?

969


Why we need to use secondry database file? though, we can do same work using primary database file also.

6843


What is filtered index?

1077


What is self join in sql server joins?

1031


What do you understand by check constraint in sql server?

929


What is autocommit mode in sql server?

1146


Where is my database stored on the hard disk in ms sql server?

1041


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1016


What is system stored procedures?

1026


Why it is recommended to avoid referencing a floating point column in the where clause?

949


What is the difference between functions and scalar functions?

1189


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2050


What is coalesce and check constraint in sql server?

1095


What is the difference between composite index and covering index?

934