with cte as ( select row_number() over (order by employee

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

Question Posted / vj

Answer Posted / vj

with cte as
(
select row_number() over (order by employee_salary desc)
maxSal ,* from Employee_Test)
select * from cte where maxSal=1

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain what role entity and relationship play in an ER diagram.

1115

How to download microsoft sql server 2005 express edition?

1096

What security features are available for stored procedure?

1080

What is the difference between count () and rowcount ()?

1080

Does group by sort data?

949

Is truncate a dml command?

1001

Why should one not prefix user stored procedures with ‘sp_’?

1100

Where is my database stored on the hard disk in ms sql server?

1111

Does sql server 2000 clustering support load balancing?

1027

what is spatial nonclustered index

1042

Tell me what are the essential components of sql server service broker?

991

what are the important architecture components of SSRS?

146

What is bcp? When does it use?

992

How to change the data type of an existing column with "alter table" statements in ms sql server?

1040

What is sql server locking?

1036