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

Write a query to get all details of employee who has maximum
salary from employee table

Answer Posted / krishh

SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);

Is This Answer Correct ?    23 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database black box testing?

1037


Explain different types of self contained sub query?

1052


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2034


Write the SQL query to drop, truncate and delete table.

979


Why main is user defined function?

1017


Explain few of the new features of sql server 2008 management studio

923


What are the recovery models for a database?

1109


What is dbcc command in sql server?

1097


How do I edit a procedure in sql server?

964


List the different index configurations possible for a table?

937


What is difference between equi join and natural join?

1047


Can we use custom code in ssrs?

1120


Explain what is the use of custom fields in report?

930


How to set database to be read_only in ms sql server?

1016


What is 3nf normalization form?

1121