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

Explain about unique identifier data type in sql server?

596

What is 2nf normalization?

637

What is the purpose of object explorer and its features? : sql server management studio

713

How do you troubleshoot errors in a SQL Server Agent Job?

645

What are the different types of data sources in ssrs?

155

How do I open a .db file?

578

What is purpose of normalization?

623

How to throw custom exception in Stored Procedure?

672

Why is the need for data conversion transformations?

587

What are the rendering extensions of ssrs?

113

How can i Relate Tables in SSIS

689

Can you insert NULL in unique column?

732

How can I create a report based on a query? : sql server management studio

648

how can you check the level of fragmentation on a table? : Sql server administration

623

Write the syntax for stuff function in an sql server?

628