1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / lama

Answers were Sorted based on User's Feedback



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

Answer / suresh jp

select emp_no,max(salary) over() from table_employee;

Is This Answer Correct ?    7 Yes 0 No

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

Answer / nitin sane

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

Is This Answer Correct ?    2 Yes 0 No

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

Answer / mithilesh gatole

Answer -

select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What command would you use to add a column to a table in sql server?

0 Answers  

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

Explain couple pf features of SQL server

2 Answers  

What language is sql server written in?

0 Answers  




Benefits of Stored Procedures?

0 Answers   Wipro,

explain different types of joins? : Sql server database administration

0 Answers  

What is the contrast between sql and pl/sql?

0 Answers  

What is the difference between index seek vs. Index scan?

0 Answers  

Can group functions be used in the order by clause in ms sql server?

0 Answers  

what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

What is transaction server isolation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories