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 run sql profiler?

1118

---

How does a trigger work?

1145

---

How many indexes can be created on a table in sql?

1114

---

How many subqueries can be nested in a statement?

1040

---

What are the three forms of normalization?

1092

---

What is sqlerrd?

1015

---

Can we use rowid as primary key?

1044

---

Is delete faster than truncate?

1052

---

What are the types pl/sql code blocks?

1196

---

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

1045

---

What schema means?

939

---

what is a constraint? Tell me about its various levels. : Sql dba

1049

---

What are the benefits of stored procedures?

1126

---

How do you remove duplicate records from a table?

981

---

Why we use triggers in mysql?

1038

---