HI, Include equal to (=) in that query: select * from temp

I want to know last five transactions or records from emp
table, from now?

Question Posted / vasanth

11 Answers
20983 Views
Wells Fargo, I also Faced
E-Mail Answers

Answer Posted / vasanth

HI,

Include equal to (=) in that query:

select *
from temp_search
minus (select *
from temp_search
where rownum <= (select count(*) - n from
temp_search))

Another example:

select xx.*
from (select rownum rr, a.* from temp_search a) xx
where xx.rr > (select count(1) - n from temp_search)

*- n : no of last tranactions

Is This Answer Correct ?

4 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql considered coding?

1048

What is a unique constraint?

1077

What are %type and %rowtype for?

1052

What is insert command in sql?

1131

What does select top 1 do in sql?

1098

What are transaction and its controls?

1040

Explain ddl statements in pl/sql?

1010

Explain the insert into statements in sql?

1007

What is a database? Explain

1113

How do you rank data in sql?

1006

How long it takes to learn pl sql?

1010

When sql appeared?

1102

What is error ora-01000: maximum open cursors exceeded

1147

How to run sql commands in sql*plus?

1183

What is implicit cursor in pl sql?

1094