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
how many tables will create when we create table, what are they? : Sql dba
What are different types of statements supported by sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
what is view? : Sql dba
What is sql indexing?
How does cross join work?
What is the difference between a primary key and a unique key?
What is mdb stand for?
What are the basic sql commands?
What do you understand by pl/sql cursors?
What is the least restrictive isolation level? : Transact sql
What is field delimiter?
Why do we need databases?
What is auto increment?
How do you create a unique index?