Answer / prakash r

Hi,

Please try the below query

Table
------
create table TEMP_SEARCH
(
F1 VARCHAR2(100),
F2 VARCHAR2(100),
F3 VARCHAR2(100)
)

select * from TEMP_SEARCH

Rownum F1 F2 F3
-----------------------------
1 1 500 DES1
2 2 600 DES2
3 3 550 DES3
4 4 760 DES4
5 5 899 DES5

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

This will give the last two transaction

What is sql profiler in oracle?

0 Answers  

---

Can we call stored procedure in function?

0 Answers  

---

What are the advantages of indexing?

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

What do you mean by rowid?

0 Answers  

---

What is bitemporal narrowing?

0 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

Can we rollback after truncate?

0 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

Does a join table need a primary key?

0 Answers  

---