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

How do I count records in sql?

943

---

How do I trace sql profiler?

920

---

how many triggers are allowed in mysql table? : Sql dba

995

---

what are the 'mysql' command line options? : Sql dba

1016

---

What is difference between sql function and stored procedure?

942

---

How many functions are there in sql?

962

---

What are the packages in pl sql?

966

---

How to fix oracle error ora-00942: table or view does not exist

955

---

What is memory optimized table?

985

---

Which sql statement is used to return only different values?

953

---

What do you understand by exception handling in pl/sql?

962

---

Which sorts rows in sql?

968

---

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

1051

---

Write a query to display the current date in sql?

967

---

What is pl/sql language case sensitive?

1059

---