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

An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).









Answer Posted / reshu singhal

select name from employee where sal = (select max(sal) from
employee)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an index on a view?

986


What is a DBMS, query, SQL?

995


Explain encryption of entire databases without the need for application changes in sql server 2008?

994


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1043


What is an inner join?

914


Differentiate between a primary key and a unique key.

998


How to turn on the mssql api module in php?

1015


What are cascading parameters in ssrs reports?

212


What is the difference between TRUNCATE and DROP?

1064


what are the important architecture components of SSRS?

124


How many categories of functions based their return modes?

1061


Explain query editor regions

1003


Explain the xml support sql server extends?

981


What are the types of containers in ssis?

1091


what are the reporting service components in SSRS?

151