select sal from emp where rownum=2 order by sal desc;

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / varun

69 Answers
116130 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / varun

select sal from emp where rownum=2 order by sal desc;

Is This Answer Correct ?

6 Yes

19 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is raw datatype in sql?

981

What is the sql query to display the current date?

992

What will you get by the cursor attribute sql%found?

901

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

2072

what happens if null values are involved in expressions? : Sql dba

1001

What is cross join example?

942

How do you take the union of two tables in sql?

934

What is database sql?

988

what is sql in mysql? : Sql dba

1123

What is normalisation in sql?

1005

What is the purpose of normalization?

997

define sql update statement ? : Sql dba

1051

What is difference between nchar and nvarchar?

958

Explain the uses of control file.

994

What is an emotional trigger?

932