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 data control language (dcl)?
What is sql and explain its components?
What are the different dml commands in sql?
What is time based sql injection?
Why do we need cursor in pl sql?
How can you fetch common records from two tables?
How can a function retun more than one value in oracle with proper example?
How many types of keys are there in sql?
Why query optimization is needed?
what is oracle database ? : Sql dba
What is the advantage of nosql?
Which is faster view or stored procedure?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
how to create a new table by selecting rows from another table in mysql? : Sql dba
how to fetch alternate records from a table? : Sql dba
