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

What do you mean by a Composite primary key?

1114

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1213

What is the main purpose of having conversation group?

910

What are the indexes in sql server?

1127

what are the disadvantages of cursors? : Sql server database administration

1039

Give an example of SQL injection attack ?

1014

Define Unique Key?

1026

How many databases Microsoft SQL server provides?

1102

What does it mean to normalize a database and why would you do it?

990

What is sql profiler. What are the default templates with it? : sql server database administration

1056

Explain a checkpoint?

1048

Explain the creation and execution of a user-defined function in the sql server?

1059

What are the different types of collation sensitivity in sql server?

1120

What is compression - row-level and page-level compression?

923

What is sleeping status in sql server?

1033