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

what are the Prerequisites for Replication?

11340

Explain can SSRS reports Cache results?

158

What stored by the tempdb ? : sql server database administration

1037

How to execute a stored procedure in ms sql server?

1152

What is ms sql server service broker?

979

what is isolation level at dead lock?

2142

Explain the difference between delete,drop and truncate in SQL Server?

1087

Where cross join is used?

951

How to modify existing triggers using "alter trigger"?

1004

What is instead of trigger sql server?

989

In which tcp/ip port does sql server run? Can it be changed?

982

Write a SQL queries on Self Join and Inner Join.

1035

How to delete duplicate records based on single column from a table?

1040

What are the advantages of using cte?

1005

What do you mean by the term 'normalization'?

1191