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

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

Question Posted / ratnakar mishra

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

More Oracle General Interview Questions

what are indexes..how many types of index's are there and what are they?

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

Indexes in oracle ?

What is a sub query? What are its various types?

what is difference between foreign key and reference key

Write a syntax for update query in oracle?

What are the different types of trigger and explain its various uses and functions?

What happens if the update subquery returns multiple rows?

Can objects of the same schema reside in different tablespace?

Explain the use of consistent option in exp command.

Explain what are the advantages of views?

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

For more Oracle General Interview Questions Click Here