how to find the second highest salary from emp table?
Answer Posted / shanmugasundaram
select min(salary) from tblempsal where salary in(select
distinct
top 2 salary from
tblempsal order by salary desc)
| Is This Answer Correct ? | 20 Yes | 13 No |
Post New Answer View All Answers
Does access use sql?
What is cartesian join in sql?
Differentiate pl/sql and sql?
What is cursor and its types?
How do I install sql?
How to fetch alternate records from a table?
What is dml statement?
Can we update views in sql?
What is having clause in sql?
what are aggregate and scalar functions? : Sql dba
What is sql resultset?
What are tables in sql?
What are the types of keys?
What is time based sql injection?
What is anonymous block in sql?