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
- 26918 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sum
select * from employees where rownum between 100 and 120
| Is This Answer Correct ? | 2 Yes | 15 No |
Post New Answer View All Answers
What is difference between stored function and application function?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How do I filter in sql profiler?
what is the difference between join and union? : Sql dba
explain the difference between delete , truncate and drop commands? : Sql dba
Explain the working of primary key?
Explain exception handling in pl/sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is the difference between cross join and natural join?
What types of commands can be executed in sql*plus?
What are the advantages of sql?
what is the bond code in materialized view?
How do I find duplicates in a single column in sql?
What is the process of debugging?
