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

Why use “pivot” in sql server?

1040

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

932

What are the different types of triggers in SQL SERVER?

1047

Explain Capacity planning to create a database? and how to monitor it?

4140

Explain the working of sql privileges?

1033

Explain raiserror in sql server?

961

What the class forname () does?

970

Write a query to find 5th highest amount paid from the customer table.

879

What are the results of running this script?

859

What is sql server agent and what are the two modes of authentication in sql server?

990

What are the difference between “where” and “having” clause in sql server?

1000

What is a full text index?

871

How to execute the cursor queries with "open" statements?

1093

What is public role in sql server?

1064

What is best institute to Learn DotNET And SQL in chennai?

2113