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

What is use of except clause? How it differs from not in clause?

1022


What is data source view or dsv? : sql server analysis services, ssas

1007


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

984


What is the ‘fillfactor’?

973


What does normalization do to data?

1078


How to find tables without indexes?

1090


How do I run sql server 2014?

1009


What are the differences between web role and worker role?

122


Describe different Processing Modes offered by SSRS?

251


How to stop log file growing too big?

1019


What is the use of sign function?

1129


What are the steps to take to improve performance of a poor performing query? : sql server database administration

1057


What is collation sensitivity? Explain different types.

1016


What is the tcp/ip port on which sql server runs?

1165


what is an extended stored procedure? : Sql server database administration

1063