August 19, 2012

Find remain data from a table using sql select query

 If there are two table A,B in which three column a,b,c are common. I have to find rest of record in A which are not in B.

select * from table1 minus select * from table2

You can see some examples in link below

Queries in Oracle

You can get sql tutorial here

SQL select Examples

No comments:

Post a Comment