A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / nayana
select * from emp where rownum<121
minus(select * from emp where rownum<100)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the function that is used to transfer a pl/sql table log to a database table?
What is the use of sql trace?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the maximum number of triggers, you can apply on a single table?
What are the triggers associated with image items?
What is localdb mssqllocaldb?
What are different types of queries in sql?
What is loop in pl sql?
Is primary key clustered index?
Where the sql database files are stored?
How do you update f as m and m as f from the below table testtable?
What is meant by truncate in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
What will you get by the cursor attribute sql%rowcount?
What is a primary key? Explain