Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the three forms of normalization?

1050


What are aggregate and scalar functions?

1032


How do I remove all records from a table?

1084


What if we write return in procedure?

1438


What is Collation Sensitivity ? What are the various type ?

960


How do you update sql?

994


how to use regular expression in pattern match conditions? : Sql dba

1043


Explain how exception handling is done in advance pl/sql?

1004


What are the ddl commands?

1020


What is date functions?

1037


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1081


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?

1141


What is range partitioning?

975


What is an implicit commit?

1060


Is microsoft sql free?

1109