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

select distinct A.id,A.salary from employee A,employee B
where A.salary = B.salary and A.id <> b.id;

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain trigger and its types?

1115


What is sql server transaction log file?

1105


How can windows applications connect to sql servers via odbc?

1178


Do you know query execution plan?

1265


What is field in algebra?

1092


What are the types of subscriptions in SQL Server replication?

1104


what is database replication? : Sql server database administration

1129


What are the encryption mechanisms in sql server?

1080


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

946


What is the osql utility?

1036


How to truncate the log in sql server 2012? : sql server database administration

1345


How can you insert null values in a column while inserting the data?

1343


how will add additional conditions in sql?

1170


How to change parameter value inside the report?

169


query processing

2220