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 Replication?
What happens if time-only values are provided as date and time literals?
Explain tablesample?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Does full backup break log chain?
Explain indexes disadvantages?
What is the maximum row of a size?
How do you rename a table in sql server?
What does it mean to invest in the index?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can I use sql azure as a backup with log shipping or database mirroring?
Which data type columns are the best candidates for full-text indexing?
What are the properties of primary key?
How does recursive cte works in sql server?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?