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

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

959

What is table constraint?

989

How many databases instances are there in sql server 2000?

1096

How to stop log file growing too big?

1012

How do you set a trace flag in sql server?

1033

Explain the cursor lock types?

1048

What is the purpose of the tempdb database?

998

How to configure odbc dsn with different port numbers?

1083

What is data source object?

999

How to rebuild all indexes on a single table?

1055

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1044

What are the advantages of using third-party tools?

990

What are number line correlation administrators will use while working with a subquery?

1173

Explain how to use linked server?

989

What are the five characteristics of good data?

913