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

Why stored procedure is faster than query?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

How do I quit sql?

0 Answers  

---

Can we change the table name in sql?

0 Answers  

---

Do prepared statements prevent sql injection?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

What is trigger in flip flop?

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

What is pl sql architecture?

0 Answers  

---

What is a temporal data type?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

How do you use join?

0 Answers  

---