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

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,


Can you explain powershell included in sql server 2008?

0 Answers  


How to assign new column names in a view?

0 Answers  


What are scheduled tasks in sql server?

0 Answers  


What is triggers in ms sql server?

0 Answers  






What are the pros and cons of creating extended stored procedures?

1 Answers  


What is 4nf in normalization form?

0 Answers  


Which are the new data types introduced in sql server 2008?

0 Answers  


How to use the inserted and deleted pseudo tables?

0 Answers  


What is nonclustered index on computed columns?

0 Answers  


Explain few of the new features of sql server 2008 management studio

0 Answers  


What is the exact numeric data type in sql?

0 Answers  


Categories