In Oracle select marks from (select marks from (select marks from stud

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / rakesh

Answer Posted / rakesh

In Oracle

select marks from
(select marks from
(select marks from students order by marks desc)
where rownum<3
order by marks asc)
where rownum<2

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Differentiate between SQL and ORACLE joins and write their syntax.

976

What is the difference between dbcc indexdefrag and dbcc reindex?

930

What is the log shipping?

952

Define ACID properties in a Database?

1004

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

963

What is the default port for SQL Server over a firewall?

1030

What is bit data type?

978

how to use DTS package in 2000,2005,2008 in sql server

1786

what are triggers? : Sql server database administration

863

Explain the functionalities that views support?

1044

What are the approximate numeric data types?

876

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

976

How can we rewrite sub-queries into simple select statements or with joins?

921

What happens if you insert a duplicate key for the primary key column in ms sql server?

934

How to check if stored procedure is running in sql server?

960