how u can find the n row from a table?
Answer Posted / rama krishna
If you want nth record from table employee then..
select * from employee where rownum <= n
minus
select * from employee where rownum < n
the above query will suffice.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is meant by temporal data?
What is sql partition function?
What is a clob in sql?
what is uncommittable transactions? : Transact sql
Why function is used in sql?
Can a table contain multiple primary key’s?
What is the difference between instead of trigger and after trigger?
What is 19 null in sql?
Why do we use function in pl sql?
What is type and rowtype in pl sql?
what is transaction? : Sql dba
Which one is faster ienumerable or iqueryable?
What is dba in sql? : SQL DBA
What is database migration?
Why schema is used in sql?