display records from 5 to 9 using rowid or rownum
Answer Posted / vinay shankar
select * from emp
where rownum <=9
minus
select * from emp
where rownum <5
| Is This Answer Correct ? | 31 Yes | 6 No |
Post New Answer View All Answers
What are the three forms of normalization?
What are aggregate and scalar functions?
How do I remove all records from a table?
What if we write return in procedure?
What is Collation Sensitivity ? What are the various type ?
How do you update sql?
how to use regular expression in pattern match conditions? : Sql dba
Explain how exception handling is done in advance pl/sql?
What are the ddl commands?
What is date functions?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is range partitioning?
What is an implicit commit?
Is microsoft sql free?