select Employee_name,max(Employee_Salary) over() from Employee

how to get max salary with employee number by using one select
query and max function ??

Question Posted / nitin sane

Answer Posted / nitin sane

select Employee_name,max(Employee_Salary) over() from Employee_test;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to have clustered index on separate drive from original table location?

975

How to join two tables in a single query in ms sql server?

1004

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1175

What is the purpose of update statistics and scope_identity() function?

1109

What do you mean by a dependent functionality in a build?

1164

System requirements for sql server 2005 express edition?

1038

What do you understand by integration services in sql server?

972

What gets stored inside msdb database?

1263

Do you know exporting and importing utility?

1052

What is a bit datatype?

994

What is database isolation in sql server? : sql server database administration

1121

what are candidate key, alternate key and composite key? : Sql server database administration

926

Why use view instead of a table?

959

What is the difference between system objects and user objects?

1172

Explain a join?

1074