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
- 13442 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / subrata sinha roy
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is use of dbcc commands?
How to find the list of fixed hard drive and free space on server?
How to access the inserted record of an event?
do views contain data ?
What is partition index in sql server?
Where are full-text indexes stored?
What is the maximum length of an alert name?
What is a trigger what are the advantages of trigger?
How to backup encryption key ?
Define clusters?
What is the process of normalization?
Explain ranking functions?
List all the types of user-defined functions?
How does recursive cte works in sql server?
What are the mathematical functions supported by sql server 2005?
