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

Explain nested join?

989

Please differentiate between a local and a global temporary table?

1008

what is a self join? : Sql server database administration

1046

What is #temp and @table variable in SQL server?

1096

How many replicas are maintained for each sql azure db?

124

How many types of attribute relationships are there? : sql server analysis services, ssas

1080

What is a ddl statement?

919

What are system databases into sql server (2005/2008)?

1003

What are group functions in query statements in ms sql server?

1011

Explain the disadvantages of cursors?

1144

What is the difference between online clustering and Offline clustering?

2419

What are the character string functions supported by sql server 2005?

1016

What are orphan records?

933

Difference between primary key and clustered index?

1013

Can you import Microsoft Excel data to SSRS?

132