Home » SQL & PL/SQL » SQL & PL/SQL » Select updated rows from one table (SQL Devloper)
icon1.gif  Select updated rows from one table [message #590026] Sat, 13 July 2013 12:32 Go to next message
rahul1010
Messages: 2
Registered: July 2013
Junior Member
There are two tables like I posted below.
I want a SQL query which selects all the rows from TABLE A which are not present in TABLE B. Also the select statement should pick all those rows which has updated value of COL_A2 in TABLE A.

TABLE A
COL_A1 COL_A2

AAA MOBILE
BBB TABLET
CCC DESKTOP
DDD UNKNOWN


TABLE B
COL_B1 COL_B2

AAA MOBILE
BBB UNKNOWN
CCC DESKTOP

The select statement should return following rows from TABLE A
COL_A1 COL_A2
BBB TABLET
DDD UNKNOWN



Re: Select updated rows from one table [message #590029 is a reply to message #590026] Sat, 13 July 2013 12:38 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
select * from table_a
minus
select * from table_b
Re: Select updated rows from one table [message #590045 is a reply to message #590029] Sat, 13 July 2013 13:12 Go to previous message
rahul1010
Messages: 2
Registered: July 2013
Junior Member
Thank You Littlefoot.
It worked Smile
Previous Topic: decode with like operator
Next Topic: Update Query Needed
Goto Forum:
  


Current Time: Mon Jul 28 07:02:14 CDT 2014

Total time taken to generate the page: 0.11562 seconds