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).
- 9 Answers
- 13434 Views
- ADP, I also Faced
- E-Mail Answers
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 a db view?
how to invoke a trigger on demand? : Sql server database administration
How can you find out how many rows returned in a cursor?
If a table does not have a unique index, can a cursor be opened on it?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Explain active/passive and active/active cluster configurations?
Explain atomicity?
How to see the event list of an existing trigger using sys.trigger_events?
How to see existing views in ms sql server?
What are the advantages of mirroring?
What are the benefits of filtered indexes?
What is RMS migrations?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Tell me about builtinadministrator?
what are the three command line utilities and what are their primary functions?
