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 plvcmt and plvrb does in pl/sql?
What are the benefits of triggers?
What is native sql query?
How to use sql statements in pl/sql?
List the different type of joins?
what is a foreign key ? : Sql dba
How can we make an if statement within a select statement?
How many primary keys can a table have?
How to use boolean type in select statement?
What is a relationship and what are they?
What are triggers in sql?
What is use of package in pl sql?
What is restrict in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
what is bdb (berkeleydb)? : Sql dba
