Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32085 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / apurva
Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Why we use pl sql?
how to add a new column to an existing table in mysql? : Sql dba
Differentiate pl/sql and sql?
What is the primary use of normalization?
What is field delimiter?
How many sql statements are used? Define them.
What is the difference between explicit and implicit cursors in oracle?
Why select is used in sql?
How does sql developer connect to oracle database?
What is the plv (pl/vision) package offers?
Do stored procedures prevent sql injection?
What is record in pl sql?
How do I partition in sql?
What is sql character function?
