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

What is partition index in sql server?

0 Answers  


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  


can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


Can you please differentiate between a primary key and a unique key?

0 Answers  


What new changes are being made in SQL Server?

0 Answers   Blue Star,






Explain aggregate functions?

0 Answers  


What is inner join in sql server joins?

0 Answers  


How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,


wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,


What is schemabinding a view?

0 Answers  


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,


What is factless fact table? : sql server analysis services, ssas

0 Answers  






Categories