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

13 Answers
18236 Views
Synechron, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2082

How to fetch alternate records from a table?

1183

What does the acronym acid stand for in database management?

1003

Is merge a dml statement?

943

Can we rollback truncate?

962

What is the requirement of self-join?

1060

Why do we use procedures in sql?

1044

What is rownum and rowid?

1001

Is sql an operating system?

982

What is bind variable in pl sql?

999

what are the difference between clustered and a non-clustered index? : Sql dba

997

What is sql profiler in oracle?

1034

What is an example of translating a date into julian format?

1063

how to include comments in sql statements? : Sql dba

926

Is sql better than excel?

1085