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

What do you know about system database? : SQL Server Architecture

1041


What is serializable?

1090


Explain indexed views and partitioned view with their syntax.

1196


What is efficiency data?

1004


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1012


what is datawarehouse?

1159


Explain partitioned view?

1133


What is the datatype of rowid?

966


there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

968


How to generate create table script on an existing table in ms sql server?

1197


Explain having clause?

1030


What are the different acid properties?

1122


How does stuff differ from the replace function?

1064


What is the library index called?

1113


what does the automatic recovery do? : Sql server administration

1081