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...


i need query for displaying the eno,ename in a table from row
2 to row 5



i need query for displaying the eno,ename in a table from row 2 to row 5..

Answer / mahesh

ans 1 -

select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5

------------------

we can also use row_number function

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More Database Management Interview Questions

What is the most used database?

0 Answers  


If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  


What is a database in layman terms?

0 Answers  


What is sql in dbms?

0 Answers  


What is database management system(dbms) and why it is used?

0 Answers  


Where is the database stored?

0 Answers  


What is difference between database and website?

0 Answers  


What is the use of FILE option in EXP command ?

1 Answers  


Does netlib support windows 95?

0 Answers  


What is rdbms architecture?

0 Answers  


how Data is stored in a file so that Direct Searching can be performed

0 Answers   HCL,


What are different cursor types in dbms?

0 Answers  


Categories