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
What is use of except clause? How it differs from not in clause?
What is data source view or dsv? : sql server analysis services, ssas
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is the ‘fillfactor’?
What does normalization do to data?
How to find tables without indexes?
How do I run sql server 2014?
What are the differences between web role and worker role?
Describe different Processing Modes offered by SSRS?
How to stop log file growing too big?
What is the use of sign function?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is collation sensitivity? Explain different types.
What is the tcp/ip port on which sql server runs?
what is an extended stored procedure? : Sql server database administration