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 are the indexing methods?
Does sql view stored data?
What are different joins used in sql?
How many triggers can be applied to a table?
Is sql developer case sensitive?
What are the most important characteristics of pl/sql?
Is natural join same as inner join?
how to get a list of all tables in a database? : Sql dba
What is a left inner join?
Is progress software supports to ( pl/sql )?
Which is better join or subquery?
How do you update f as m and m as f from the below table testtable?
I need a function for a train ticket reservation please answer it thanks in advance
What has stored procedures in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
