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
how many sql dml commands are supported by 'mysql'? : Sql dba
Why do we use %rowtype & %type in plsql?
What is the command used to fetch first 5 characters of the string?
Define concurrency control. : Transact sql
how to use in conditions? : Sql dba
What is linq to sql?
Explain raise_application_error.
How many sql core licenses do I need?
what is denormalization. : Sql dba
Explain the difference between drop and truncate commands in sql?
how many ways to get the current time? : Sql dba
What is the use of function in sql?
What are triggers and its types?
What is sql and explain its components?
how are mysql timestamps seen to a user? : Sql dba
