Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / karthik ramasamy
Select max(salary) from salarymaster where salary <(select
max(salary) from salarymaster)
OR
SELECT MAX(SALARY) FROM SALARYMASTER WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM SALARYMASTER)
OR
Select max(salary) from salarymaster where salary<(Select
max(salary) from salarymaster)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you have more than one trigger on a table?
what is column? : Sql dba
What is a mutating table and a constraining table?
What is time based sql injection?
What is before trigger?
What is percent sign in sql?
What is ttitle and btitle?
What are triggers and its types?
how to delete an existing column in a table? : Sql dba
What is the difference between between and in condition operators?
what is commit? : Sql dba
How do you truncate?
Mention what does the hierarchical profiler does?
Does mysql_real_escape_string prevent sql injection?
Which version of sql do I have?