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

write the sql query to display 5th and 10th row in a table?

Answer Posted / gautam ramteke

select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What junk dimension contains?

988


What are the roles defined by cognos platform?

1134


Why are meta service important then other services?

970


What you mean by drill across and what is the difference between drill through, drill across?

1019


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1998


Can you define drill down and drill up?

1029


-----------With out using DrillThrough how to do Reports?

2034


in u r data u having duplicates how to fetch the latest data in our report?

5721


Explain the different types of views used in cognos.

940


What are the different uses of a repository manager?

1088


What is meant by junk dimension?

1167


what are the filters in framework manager and report studio?

986


what are the special features in cognos reportnet?

1057


What is the difference between regular dimension and derminant?

2264


What is the enterprise class platform architecture of cognos 8?

1024