how u can find the n row from a table?
Answer Posted / rashmi
select max(rownum) from table1 where rowid is not null
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
how to fetch common records from two tables? : Sql dba
What is trigger in sql?
what is the difference between char and varchar data types? : Sql dba
How to get unique records from a table?
What does closing a cursor do?
What are sql indexes?
What is prepared statement in sql?
What are pl/sql cursor exceptions?
Why do we use subquery?
what is difference between delete and truncate commands? : Sql dba
What is a temporal data type?
what is datawarehouse? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
how to include comments in sql statements? : Sql dba
Differentiate between % rowtype and type record.