Answer Posted / 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 thread join () in threading?

737

---

What are some predefined exceptions in pl/sql?

749

---

How to pipe multiline string to isql?

762

---

What is the use of %rowtype?

760

---

What is the current version of postgresql?

737

---

In pl/sql, what is bulk binding, and when/how would it help performance?

742

---

What are all the different normalization?

753

---

What language is oracle sql developer?

717

---

what is a trigger in mysql? : Sql dba

788

---

What is indexes?

760

---

What is multiple columns?

782

---

how to fetch alternate records from a table? : Sql dba

833

---

What is index example?

753

---

How do I install microsoft sql?

722

---

How do I view output in sql developer?

816

---