A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / manjunath
select level from dual connect by level<=150
minus select from dual connect by level<=120;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are commit, rollback, and savepoint?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Why are aggregate functions called so?
Does pl/sql support create command?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is insert command in sql?
What is procedure and function in sql?
Does sql view stored data?
How to handle bulk data?
Can we use ddl commands in pl sql?
What are the differences between in and exists clause?
Can a varchar be a primary key?
What are the string functions in sql?
How delete a row in sql?
How do I filter in sql profiler?