Oracle Sql Help Needed Please ?

[desiboys]

Help me please

[desiboys]

Na query idi.

Select distinct 
       T1.Pl_ID
       T1.Cost,
       T1.NO,
       T1.Date
       T5.CD,
       T5.NM
from Table1 T1
Join Table2 T2
ON T1.Pl_ID = T2.PL_ID
Join Table4 T4
ON T4.Pl_ID = T1.Pl_ID
and T4.TYP = 'Carrier'
Join Table5 T5
ON T5.Pl_ID = T1.Pl_ID
and T2.Pl_NO = T5.Pl_NO
Join INTLSTG.SHPM_PL_EQP_T T6
ON T6.Pl_ID = T1.Pl_ID
Join Table7 T7
ON T7.RD_NO = T2.RD_ID
Join Table8 T8
ON T8.RD_NO = T2.RD_ID

Output emo ilaa vasthundi kinda. Naku cost column lo duplicates chupivvakunda just one row chupinchi migitha duplicates ni null ga chupivvali. How can i do that ?

 

 

Pl_ID      Cost    NO        Date           CD           NM

1          40      1001     10/1/2014      ABC1       ABC Media
1          40      1001     10/1/2014      XYZ1       XYZ Media
1          40      1001     10/1/2014      ACD8       ACD media
1          40      1001     10/1/2014      RDE9       RDE Media
2          20      2001     10/1/2014      DER0       DER Media
3          50      3001     10/1/2014      AZS6       AZS media
4          10      4001     10/1/2014      PRE8       PRE Media
4          10      4001     10/1/2014      AXP9       AXP Media
4          10      4001     10/1/2014      PPI0       PPI Media

 

[desiboys]

help

[loveindia]

How do you determine a duplicate in your query.?

[Hitman]

It is possible with ranking functions.

 

Notes available at

 

https://docs.oracle.com/cd/B19306_01/server.102/b14223/analysis.htm#i1006336

[Tadika]

Ltt

[vikuba]

brother kani CD columns various codes unaye..kadha.

neeku ey CD kavali..or asal CD column ey vadhaa?

[vikuba]

select  T1.Pl_ID, T1.Cost,T1.NO,T1.Date count(T5.CD),count(T5.NM)

 

(

Select distinct T1.Pl_ID, T1.Cost,T1.NO,T1.Date,T5.CD,T5.NM
from Table1 T1
Join Table2 T2
ON T1.Pl_ID = T2.PL_ID
Join Table4 T4
ON T4.Pl_ID = T1.Pl_ID
and T4.TYP = 'Carrier'
Join Table5 T5
ON T5.Pl_ID = T1.Pl_ID
and T2.Pl_NO = T5.Pl_NO
Join INTLSTG.SHPM_PL_EQP_T T6
ON T6.Pl_ID = T1.Pl_ID
Join Table7 T7
ON T7.RD_NO = T2.RD_ID
Join Table8 T8
ON T8.RD_NO = T2.RD_ID

)

 

group by T1.Pl_ID, T1.Cost,T1.NO,T1.Date

 

if you execute this...you will get wat you are asking for..

 

but I am grouping them and making the CD and NM as counts..

[loveindia]

brother kani CD columns various codes unaye..kadha.

neeku ey CD kavali..or asal CD column ey vadhaa?

 

Chivariki BeerBathiBisket ayyava man.... 

[vikuba]

Chivariki BeerBathiBisket ayyava man.... 

em chesthaam chepu