how to get max salary with employee number by using one select
query and max function ??
- 3 Answers
- 7148 Views
- Genpact, I also Faced
- E-Mail Answers
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
Define self join?
Difference between report and query parameter.
What is the difference between Stored Procedures and triggers?
What is Dependency Injection and provide example?
How do you size a resultset?
Do you have any idea about the tcl commands?
What is clr ddl trigger?
What is linked report?
How to deploy the Report?
How to enter comments in transact-sql statements?
Explain what is “asynchronous” communication in sql server service broker?
What is de-normalization and what are some of the examples of it?
What happens if the update subquery returns no rows in ms sql server?
State the difference between union and union all?
How to select some specific rows from a table in ms sql server?
