how u can find the n row from a table?
Answer Posted / santosh dwivedi
select * from
(
select rownum r,a.* from TableName a
)
where r=n'th
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is the use of index in sql?
how would you enter characters as hex numbers? : Sql dba
What is sqlca in db2?
What is the purpose of primary key?
What is primary key and unique key?
What does plv msg allows you to do?
What is a recursive join sql?
What is count * 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 an intersect?
What are the different operators available in sql?
What is scalar and vector?
What is view? Can we update view
What is dynamic sql in pl sql?
How to find 3rd highest salary of an employee from the employee table in sql?