A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24583 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhradeep
select * from employees where rownum<102
minus(select * from employees where rownum<81)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between cluster and non-cluster index?
What is the difference between instead of trigger and after trigger?
what is innodb? : Sql dba
what is the difference between sql and t-sql? : Transact sql
How many types of literals are available in pl sql?
How to rename a table?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do you write an inner join query?
What is the size of partition table?
Is mariadb nosql?
What are stored procedures in mysql?
Is progress software supports to ( pl/sql )?
How delete all data from all tables in sql?
What is the difference between partition and index?
How many types of triggers exist in pl/sql?
