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
- 15805 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 is data modeling and Reterminal integrity?
What are the acid properties?
Why should one not prefix user stored procedures with ‘sp_’?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What do you understand by sql server agent?
How do I find the size of a sql server database?
What is pivot and unpivot?
What is partition, how will you implement it? : sql server analysis services, ssas
how to define testing of network layers? : Sql server database administration
What is stored in the mssqlsystemresource database? : sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?
How to recover from sql injection? : sql server security
Mention the command used to rename the database.
What are the recovery models in sql server 2000?
What are the differences between DDL, DML and DCL in SQL?
