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

How many types of index are there?

0 Answers  

---

What is 19 null in sql?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

what is the command for user data type?

2 Answers  

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

What is trigger and types?

0 Answers  

---

What is composite primary key in sql?

0 Answers  

---

Explain the PL/SQL compilation process.

3 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

What are synonyms in sql?

0 Answers  

---