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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to display last 5 records in a table ?
With out Top key word and doing order by desc

Advance thanks

Question Posted / cmanojkumar

Answers were Sorted based on User's Feedback



How to display last 5 records in a table ? With out Top key word and doing order by desc Advance..

Answer / madhu


this is can acheieve by following query

select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);

Is This Answer Correct ?    4 Yes 1 No

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance..

Answer / priyank

select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

Why we use partitioning the session in informatica?

2 Answers  

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

How to merge First Name & Last Name?

8 Answers  

What are the data movement modes in informatcia?

1 Answers  

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

Is it possible to revert a global repository to local one and why?

0 Answers  

Have you worked with/created Parameter file

0 Answers  

What is staging area?

11 Answers  

For more Informatica Interview Questions Click Here
Categories