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
- 13432 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
List out the differences between global and local temp tables in sql server?
Can we check locks in database? If so, how can we do this lock check?
Can you create a logon trigger in sql server 2005 express edition?
What is the web service used for reporting services?
How do you create type- insensitive operator?
How do you rename a table in sql server?
What are indexes in ms sql server?
Sql server reporting services vs. Crystal reports.
What sql server means?
Can two tables share the same primary key?
What is transaction server explicit transaction?
What is the difference between a clustered index and a non-clustered index?
What is an entity-relationship diagram (erd)?
What is amo? : sql server analysis services, ssas
How to create new databases with "create database" statements?
