SELECT * FROM (SELECT ROWNUM DD, M.* FROM (SELECT SAL FROM EMP order by

how to calcuate the second highest salary of he employee

Question Posted / sachin s. patil

Answer Posted / sachin s. patil

SELECT * FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between ms sql and mysql?

470

what are date and time data types in mysql? : Sql dba

489

Can we insert data into view?

516

What is the purpose of cursors in pl/sql?

631

Why procedure is used in sql?

522

How much does a sql dba make? : SQL DBA

499

What is consistency?

700

What does the file extension accdb stand for?

542

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2082

how to use in conditions? : Sql dba

503

what is commit? : Sql dba

608

how can I make a script that can be bi-language (supports english, german)? : Sql dba

532

How do you remove duplicates without using distinct in sql?

495

Is it possible to link two groups inside a cross products after the cross products group has been created?

582

What is the difference between the conventional and direct path loads? : aql loader

687