Write a query to get all details of employee who has maximum
salary from employee table
Answer Posted / sureshramsing
select * from(select e.* from emp e order by sal desc) where rownum=1;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is page-level compression?
when you create a database how is it stored? : Sql server database administration
How you can get a list of all the table constraints in a database?
How to send a ssrs report from ssis?
How can I create a report based on a query? : sql server management studio
Can you index views?
Why would you call update statistics?
how we use window authentication connection with sql server.?
What are the advantages of partitioning?
How do I setup a sql server database?
Differentiate sql server reporting services vs. Crystal reports?
What is a trigger and types of a trigger?
What do you mean by authentication modes in sql server?
define and explain the differences between clustered and non-clustered indexes.
What is the difference between SQL notification and SQL invalidation?