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).
- 9 Answers
- 15812 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / kalyan
select name,max(sal) from emp group by name
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
Explain left outer join and right outer join?
What is difference between equi join and natural join?
Why should one not prefix user stored procedures with ‘sp_’?
After removing a table from database, what other related objects have to be dropped explicitly?
Explain sql server authentication modes?
What are the requirements for sql server 2016?
What do you think of this implementation? Can this be implemented better?
What are the elements of dbms?
What is side by side migration in sql server?
Why we use trigger in sql server with example?
What are two difference between sql azure and azure tables?
How to create a store procedure with encryption?
What does top operator do?
How do you drop an index?
Does partitioning improve performance?
