select * from emp where (empno,1)=(select * from(select empno,row

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

Question Posted / sureshramsing

Answer Posted / sureshramsing

select * from emp where (empno,1)=(select * from(select empno,row_number() over(order by sal desc) rn from emp) where rn=1);

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is sparse columns of sql server 2008?

995

How to use user defined functions in expressions?

1009

can we have a nested transaction? : Sql server database administration

994

What are the different types of upgrades that can be performed in sql server?

1119

How to defragment indexes with alter index ... Reorganize?

1028

Give an example of why you would want to denormalize a database

928

What are translations and its use? : sql server analysis services, ssas

995

Define tempdb database?

944

Ways to improve the performance of a SQL Azure Database?

123

What are acid properties of transaction?

895

What is the use of sign function?

1036

Is the primary key column of a table an index in ms sql server?

920

When is the use of update_statistics command?

953

Write SQL queries on Self Join and Inner Join.

1072

What are the advantages of the mirroring?

1015