this is can acheieve by following query select * from(select rowunum

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

Advance thanks

Question Posted / madhu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Could you explain what is enterprise data warehouse?

1046

Define mapplet?

961

explain abt ur project architecture?

2121

Explain about cumulative Sum or moving sum?

976

How union transformation is used?

954

Explain the pipeline partition with real time example?

1083

Which means the first record should come as last record and last record should come as first record and load into the target file?

1020

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9735

How you can differentiate between connected lookup and unconnected lookup?

1005

Explain lookup transformation in informatica

1004

How identifying bottlenecks in various components of informatica and resolving them?

1055

What are mapplets? How is it different from a Reusable Transformation?

1031

What is lookup change?

985

Enterprise data warehouse your projects phase by phase explain?

1856

Write the advantages of partitioning a session?

1203