how to find the second highest salary from emp table?
Answer Posted / jitendra kumar
select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we delete column in sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is a system versioned table?
What is the most common sql injection tool?
what is a unique key ? : Sql dba
what is 'mysqlcheck'? : Sql dba
What will you get by the cursor attribute sql%found?
How do I copy a table in sql?
What is trigger with example?
Explain cursor types?
What does pl sql developer do?
Define commit?
Explain what is rdbms?
What is constant in pl sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?