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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between HTTP and HTTPS in database?

1037


According to you what goes into making the best database administrator? : sql server database administration

978


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1252


What happens if you insert a duplicate key for the primary key column in ms sql server?

977


How do I create a stored procedure in dbml?

1009


How to Update from select query in sql server?

1062


What are security principals used in sql server 2005?

988


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1933


Explain Geography datatype in SQL Server

1132


What is sql server programming?

1046


what are the reporting service components in SSRS?

163


How does Report Builder support Analysis Services cubes?

154


What do you mean by authentication modes in sql server?

1084


what is the difference between a primary key and a unique key? : Sql server database administration

1003


What are the advantages of using a stored procedure?

1008