I have student marks in a student table. I need second
highest mark .Then what will the query for this?
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 |
Post New Answer View All Answers
What are system databases into sql server (2005/2008) : sql server database administration
Mention the different authentication modes in sql server.
How do I find the default sql server instance?
Can you get second highest salary from the table?
What are the advantages of sql azure?
what is the sql equivaent of the dataset relation object ?
1 01 101 01010
What is auditing in sql server?
How do you know if sql server is running on your local system?
How do I start and stop sql server?
What is a filestream?
What is store procedure? How do they work?
Do you know what is fill factor and pad index?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is Dependency Injection and provide example?