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
- 16435 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / anil
select name,sal from employee where sal in(select top 5 sal from employee order by sal desc)
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
What does dml stand for?
Explain security with sql azure?
Is foreign key unique?
How to enable tcp/ip protocol on a sql server?
Name some of the open source software that you can use in alternative to SSR?
What do you understand by integration services in sql server?
how you can configure a running aggregate in SSRS?
What is query optimizer in sql server?
How do you check sql server is up and running?
What is multi-statement table-value user-defined function?
What is the difference between Normalization and De-normalization?
State a few properties of relational databases?
What is a non equi join?
What is meant by dirty read?
Is it possible in sql table to have more than one foreign key?
