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

What is an aggregator transformation?

1096

What is a sequence generator transformation?

1021

What are the prerequisite tasks to achieve the session partition?

1252

how to load rows into fact table in data warehouse

1190

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

What is rank transformation in informatica

1179

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1272

Explain in detail scd type 2 through mapping.

1041

How can you differentiate between powercenter and power map?

1091

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1269

How to elaborate powercenter integration service?

1136

Explain joiner transformation in informatica

1124

What is Cognos script editor?

4234

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

1092

During the running session, output files are created by informatica server. Enlist few of them.

982