how to find the second highest salary from emp table?
Answer Posted / moharaj m
select max(salary) from emp where salary < (select max
(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is rank function in sql?
Does view contain data?
What is the difference between numeric and autonumber?
What are different categories of sql commands?
Is sql workbench free?
What is a rank in sql?
How can you fetch common records from two tables?
Is ms sql traffic encrypted?
What is pl sql and why it is used for?
Is left join same as inner join?
What is before trigger?
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the different types of sql commands?
Explain the types of joins in sql?