A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 21880 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / d
select *
from (select rownum row_num
,tab.*
from table tab)
where row_num between 100 and 120
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are tables and fields?
What is crud stand for?
What are the ddl commands?
what are the types of subquery? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Show code of a cursor for loop.
What is a sql*loader control file?
What is dml statement?
What is t sql used for?
What are the different dcl commands in sql?
How to change sql*plus system settings?
How do you explain an index number?
What are local and global Indexes and where they are useful.
What is int identity in sql?
