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

How do I edit a procedure in sql server?

957

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

How can you insert values in multiple rows using one Insert statement?

1095

What is onf in normalization form?

1056

Can a synonym name of a table be used instead of a table name in a select statement?

1030

What is an index in a database?

979

How to create user defined functions with parameters?

1232

Define Unique Key?

1002

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

can you instantiate a com object by using t-sql? : Sql server database administration

998

Explain external key management in sql server 2008

887

How the authentication mode can be changed?

1132

How to Sync Two SQL Azure Databases?

121

What is an identity?

1018

What is the recovery model? List the types of recovery model available in sql server?

906