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
Explain syntax for dropping triggers?
Define ACID properties in a Database?
Is sql different from sql server?
How to use wildcard characters in like operations in ms sql server?
Explain view in sql server?
What is cursor in ms sql server?
What is the use of set nocount on/off statement?
How do I setup a sql server database?
What function does a database engine serve in the sql server?
Which are the olap features?
What is the use of sql profiler in sql server 2012?
What are the components of dbms?
How can I track the changes or identify the latest insert-update-delete from a table?
Can We Use Data-grids For Our Report In Ssrs?
How to throw custom exception in Stored Procedure?