select * from(select e.* from emp e order by sal desc) where rownum=1;

Write a query to get all details of employee who has maximum
salary from employee table

Question Posted / sureshramsing

Answer Posted / sureshramsing

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain following error properties?

957

What is side by side migration in sql server?

1023

List some major differences between triggers and stored procedures?

856

How to create view in stored procedure sql server?

960

Explain about remote stored procedure?

966

What is self contained scalar sub query?

931

What is a fill factor?

1035

What is normalization of database? What are its benefits?

963

How to read data in a table with "select" statements?

921

Explain what stored procedure sp_replcounters is used for? : sql server replication

1455

What are SSL and TSL protocols?

935

How to make a remote connection in a database?

927

What is a benefit of using an after insert trigger over using a before insert trigger?

931

What is the parse query button used for?

982

How to insert multiple rows with one insert statement in ms sql server?

1057