how to get max salary with employee number by using one select
query and max function ??
Answer Posted / 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 View All Answers
What is the difference between value type and reference type?
What is efficiency data?
What is a view and what are its advantages?
when would you go for denormalization? : Sql server database administration
Can we use custom code in ssrs?
What are the system database in sql server 2008?
What stored procedure can you use to display the current processes?
How to turn off warning messages during php execution?
What does the on delete cascade option do?
What is the use of floor function in sql server?
What are the different types of collation sensitivity?
where can you add custom error messages to sql server? : Sql server administration
How to replace the Query Result 'Null Value' with a text ?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is an expression in ms sql server?