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
- 27444 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / intelligent
select * from emp where rownum>101 and rownum<121
| Is This Answer Correct ? | 2 Yes | 18 No |
Post New Answer View All Answers
Explain the commit statement.
What is rtm in testing?
What is cold data?
Explain what is rdbms?
How do I view stored procedures?
What are operators available in sql?
What are the steps for performance tuning.
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
What is the use of & in pl sql?
What are functions in sql?
What is normalization in sql?
Can you rollback after commit?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Can we update views in sql?
