select * from emp minus select * from emp where rownum <= (select max(

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

Advance thanks

Question Posted / priyank

Answer Posted / priyank

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Repository user profiles

1746

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6148

What differs when we choose the sorted input for aggregator transformation?

1008

Differences between version 7.x and 8.x.

1882

What is domain and gateway node?

1153

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8207

What are the issues you have faced in your project? How did you overcome those issues?

2347

What are the measure objects?

1186

Explain lookup transformation source types in informatica

1081

What is sq transformation?

1139

What do you mean by blocking transformation?

1016

How does a sorter cache works?

1045

What is the format of informatica objects in a repository?

1009

What is difference between a gateway node and worker node?

1116

What is a repository? And how to add it in an informatica client?

1128