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

How to create a simple table to test triggers in ms sql server?

962

what is a correlated sub-query? : Sql server database administration

918

Explain user defined functions?

972

What is filter index?

933

List some case manipulation functions in sql?

1008

How to update muliple row in single query?

1036

what's sql server? : Sql server database administration

976

How do I schedule a sql server profiler trace?

966

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

1052

How to execute a sql statement using odbc_exec()?

1117

What is explicit mode in sql server?

1042

What do you mean by an execution plan? How would you view it?

904

Tell me about pre-defined functions of sql?

1096

What is the difference between sdf and mdf?

1280

What is a cursor, index in sql?

1051