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 t string functions available in tsql? : Transact sql
What are the features of pl sql?
Can pl sql procedure have a return statement?
How delete all data from all tables in sql?
What is group function in sql?
How much does sql cost?
What is difference between stored procedure and trigger?
Is oracel sql developer written in java?
What is the sql case statement?
what is top in tsql? : Transact sql
What is primary key secondary key alternate key candidate key?
What is a left join?
what is isam? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
What are field types?
