Oracle Sql

[sanbk]

Koncham Idea ivvandi ela cheyochoooo

 

Table A      Table B               Table C

                   

SSN               SSN                    SSN

1                      2                           1

2                      4                            2

2                      5                            5

2                      9

3                      10                          13

3                       11                          14

4

4

4

4

5

6

7

 

ila undi ... ippudu motham anni distinct values oka master table lo pettali..

 

Ideas pls how to implement

[CheGuevara]

Insert into master_table
select ditinct ssn from tableA
Union
Select distinct ssn from tableB
Union
select distinct ssn from tableC;

Commit;

[sanbk]

Insert into master_table
select ditinct ssn from tableA
Union
Select distinct ssn from tableB
Union
select distinct ssn from tableC;

Commit;

performance bane untada bro.. I thought slow untadi emo ani.. more tha 10 million rows unnai okka okka table lo

[dotnet_developer]

Insert into master_table
select ditinct ssn from tableA
Union
Select distinct ssn from tableB
Union
select distinct ssn from tableC;

Commit;

agreed

 

performance bane untada bro.. I thought slow untadi emo ani.. more tha 10 million rows unnai okka okka table lo

using any etl tool?

[former]

Koncham Idea ivvandi ela cheyochoooo

 

Table A      Table B               Table C

                   

SSN               SSN                    SSN

1                      2                           1

2                      4                            2

2                      5                            5

2                      9

3                      10                          13

3                       11                          14

4

4

4

4

5

6

7

 

ila undi ... ippudu motham anni distinct values oka master table lo pettali..

 

Ideas pls how to implement

 

 

SELECT 

   SSN 

FROM

( SELECT SSN FROM TABLEA 

   UNION

  SELECT SSN FROM TABLEB

   UNION

  SELECT SSN FROM TABLEC

)

GROUP BY SSN

;

 

This is better than Distinct & I assume you need remove duplicates across different table.

[sanbk]

SELECT 

   SSN 

FROM

( SELECT SSN FROM TABLEA 

   UNION

  SELECT SSN FROM TABLEB

   UNION

  SELECT SSN FROM TABLEC

)

GROUP BY SSN

;

 

This is better than Distinct & I assume you need remove duplicates across different table.

Yes I need distinct bro

[former]

Yes I need distinct bro

 

GROUP BY will do DISTINCT