display records from 5 to 9 using rowid or rownum
Answer Posted / chiru
select * from (select rownum r ,a.* from emp a ) where r between 5 and 9
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Which join is like inner join?
how to concatenate two character strings? : Sql dba
What are the types of triggers in sql?
What is cost in sql execution plan?
Explain the savepoint statement.
What is a field in a database?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Why do we use joins in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is dml statement?
Explain the steps needed to create the scheduled job?
What is difference between pls_integer and integer?
Differentiate between sga and pga.
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What are triggers and its types?