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
How do I find duplicates in sql?
What is pl/sql table? Why is it used?
What are the two types of exceptions.
what is the difference between a having clause and a where clause? : Sql dba
Why do we use triggers?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is procedure and function in sql?
Why partition by is used in sql?
What are different types of queries in sql?
what is a table in a database ? : Sql dba
Can we create clustered index without primary key?
what is text? : Sql dba
What will you get by the cursor attribute sql%notfound?
Is there a 64 bit version of ssms?
How do I run sql profiler?