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 does 0 mean in sql?

530

---

What is a sql select statement?

573

---

How do I run a script in sql developer?

497

---

What are the different types of sql commands?

602

---

What is sql lookup?

516

---

---

Difference between global and parameter variables?

1461

---

How to rename a column in the output of sql query?

539

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

573

---

How do I add a database to sql?

584

---

Which is better cte or subquery?

544

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1728

---

How do I run a sql query in pgadmin 4?

548

---

Can we use ddl statements in stored procedure sql server?

520

---

What is trigger in pl sql with examples?

525

---

what is normalization? : Sql dba

563

---