A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
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 string data type in sql?
what are the differences between binary and varbinary? : Sql dba
How do I truncate a sql log file?
What are stored procedures used for?
Explain the significance of the & and && operators in pl sql.
What is the use of desc in sql?
What are different clauses used in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What are types of joins?
How do you write a subquery?
Describe different types of general function used in sql?
What is the difference between an inner join and an outer join?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What will you get by the cursor attribute sql%rowcount?
what are all types of user defined functions? : Sql dba