How will you write a query to get a 5th rank student from a table student_report?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What privilege is needed for a user to delete rows from tables in another schema?

0 Answers  


Please explain the difference between outer join and inner join? With examples would be appreciable..!

6 Answers   IBM,


How to select some rows from a table in oracle?

0 Answers  


How to find 1st, 2nd, 3rd highest using select select statement not using rownum

2 Answers  


What do you understand by a database object? Can you list a few of them?

0 Answers  






I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  


How to update values in a table in oracle?

0 Answers  


What is ceil and floor in oracle?

0 Answers  


Explain drop constraint oracle?

0 Answers  


What is a database table in oracle?

0 Answers  


How to lock and unlock a user account in oracle?

0 Answers  


can u plz provide me oca sql dumps please i need them

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)