Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bikash khuntia
Hi Freinds,
I have seen the solution given. But in oracle if you will
select records from a table then everytime you will not
fetch the same squence of records. it will come
differently.Hence we cannot select the 5th row from a table
in oracle.
But the solution is that we can select 5th row from a table
in arranging the records in ascending or descending way by
a column and then select the 5th row as below:-
SELECT BIKK.SAL FROM
(SELECT ROWNUM RW,BIK.SAL SAL FROM (SELECT SAL FROM
TEMP_SAL ORDER BY SAL) BIK) BIKK
WHERE rw=6
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are secondary keys?
What is the difference between left and left outer join?
Explain the order of sql statement execution?
What is sqlite format?
What does fetching a cursor do?
what is self-join? : Sql dba
Can a foreign key be null?
Why left join is used in sql?
Why use stored procedures?
How do I copy a table in sql?
What is bind reference and how can it be created?
What are the types of index in sql?
What is the difference between an inner and outer join?
What is a pragma statement?
