select sal from emp where rownum=2 order sal by Desc

how to find the second highest salary from emp table?

Question Posted / sachin verma

Answer Posted / sachin verma

select sal from emp
where rownum=2
order sal by Desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select random rows from a table?

1081

Are views faster than queries?

997

What is difference between stored procedures and application procedures?

1021

explain advantages of myisam over innodb? : Sql dba

1071

what is table? : Sql dba

1068

Does db2 use sql?

954

What is oracle sql developer?

1068

What do you think about pl/sql?

1041

What does sign mean sql?

1121

What is an oracle stored procedure?

1058

Why is the cursor important?

1046

Is primary key is clustered index?

1002

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1064

How do sql databases work?

1003

List and explain the different types of join clauses supported in ansi-standard sql?

1358