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
Explain following error properties?
What is side by side migration in sql server?
List some major differences between triggers and stored procedures?
How to create view in stored procedure sql server?
Explain about remote stored procedure?
What is self contained scalar sub query?
What is a fill factor?
What is normalization of database? What are its benefits?
How to read data in a table with "select" statements?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are SSL and TSL protocols?
How to make a remote connection in a database?
What is a benefit of using an after insert trigger over using a before insert trigger?
What is the parse query button used for?
How to insert multiple rows with one insert statement in ms sql server?