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

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 ?    4 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 ?    1 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

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,


What is the SQL?????????????????????????????

5 Answers   CMS,


What happens if an integer is too big for int date type?

0 Answers  


What types of integrity are enforced by a foreign-key constraint

1 Answers  


Define indexes?

0 Answers  






When is the use of update_statistics command?

0 Answers  


Display a roll having miminum marks in two subjects?

7 Answers   Patni,


Explain microsoft sql server functions?

0 Answers  


What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  


Explain how many types of relationship?

0 Answers  


how to generate XML out of QUERY?

1 Answers   McAfee,






Categories