Interested to Buy Any Domain ? << Click Here >> for more details...
A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 27414 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sravan
select * from emp where rownum<151
minus(select * from emp where rownum<121)
| Is This Answer Correct ? | 13 Yes | 14 No |
Post New Answer View All Answers
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is record variable?
How many commands are there in sql?
What is a dirty read sql?
What is the use of partition by in sql?
Why do we use joins?
How do we use distinct statement? What is its use?
What is attribute indicator in pl sql?
What is recursive join in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Is join an inner join?
Why do we use function in pl sql?
What is use of trigger?
Why is pl sql needed?
