| Author |
Message |
    
Mrbezawada
Pilla Bewarse
Username: Mrbezawada
Post Number: 153
Registered: 10-2011
Posted From: 205.172.134.229
| | Posted on Friday, August 19, 2016 - 1:15 pm: |
|
Onlymovies..Bro..Did you resolve this?
What SQL are you using?
SQL Server or any other?
Bezawada Bewarse Batchey
|
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36165
Registered: 01-2009
Posted From: 68.134.121.172
| | Posted on Thursday, August 18, 2016 - 11:09 pm: |
|
Proofdada:
nee dashu, copy paste kaadu logic ardham chesukuni step by steppe rasaanu..
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 147427
Registered: 03-2004
Posted From: 205.145.107.101
| | Posted on Thursday, August 18, 2016 - 1:40 pm: |
|
Onlymovies:Thanks bhayya, finally got it...
copy paste cheesi names change cheesava  ... ittantivi step by step try chesukuntu povali with google help, then you will learn it, leepothe rocket science la vuntadhi eppadiki.  |
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36163
Registered: 01-2009
Posted From: 137.200.32.54
| | Posted on Thursday, August 18, 2016 - 1:05 pm: |
|
Symbol_of_king:
Thanks bhayya, finally got it...
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 2234
Registered: 12-2005
Posted From: 72.219.244.175
| | Posted on Thursday, August 18, 2016 - 10:43 am: |
|
i think your problem is outer join on two tables in same query... below query may work but may not be effective interms of performance
select 1.B,23.E
(select 2c.A,3.E from
(select A,D from 2a where 2a.C='x' and 2a.creation_dt=(select max(creation_dt) from table2b where 2a.A=2b.A and 2a.D=2b.D)) 2c, 3
where 2c.D=3.D) 23, 1 where 1.A=23.A(+) |
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 147423
Registered: 03-2004
Posted From: 205.145.107.50
| | Posted on Thursday, August 18, 2016 - 9:43 am: |
|
problem eeti?
left join cheesi data choosukokoa( left join(table1) and left join(table2) , ... nuvvu query lo c= 'x' or not validate cheyyala?
then select columns loo aa logic implement chesukunte ayipodhi ga... you are just pulling the data kadha? |
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36162
Registered: 01-2009
Posted From: 137.200.32.54
| | Posted on Thursday, August 18, 2016 - 9:36 am: |
|
Proofdada:Idhi saana visy ga om bha...perf pakkanedithe ettagayina rasukovachu ee stmt nu...
perf ante? performance aa?
elago cheppachu kadaa..
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 147419
Registered: 03-2004
Posted From: 166.137.118.62
| | Posted on Thursday, August 18, 2016 - 8:47 am: |
|
Idhi saana visy ga om bha...perf pakkanedithe ettagayina rasukovachu ee stmt nu... |
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36161
Registered: 01-2009
Posted From: 137.200.32.54
| | Posted on Thursday, August 18, 2016 - 8:34 am: |
|
Symbol_of_king:
It worked partially..
Table 2 lo C ki multiple values vundachu, C = 'x' kooda multiple rows vundachu, we have to slect latest C='x'.
how to handle this?
EDIT:::
Also table to 2 lo record leka pothe, rows return avvatam ledu.. table 2 lo record leka poyina just B, null return avaali.. adi kooda avvatam ledu
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36160
Registered: 01-2009
Posted From: 137.200.32.54
| | Posted on Thursday, August 18, 2016 - 8:13 am: |
|
Symbol_of_king:
Thanks bhayya, will try.
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 2233
Registered: 12-2005
Posted From: 72.219.244.175
| | Posted on Thursday, August 18, 2016 - 8:06 am: |
|
select B,decode(c,x, E ,null) from 1,2,3 where A = 'Given vlaue' and 1.A = 2.A(+) and 2.D = 3.D |
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 36159
Registered: 01-2009
Posted From: 137.200.32.54
| | Posted on Thursday, August 18, 2016 - 7:41 am: |
|
Table 1 lo A, B ane 2 columns vunnayi.
Table 2 lo A, C, D ane 3 columns vunnayi.
Table 3 lo D, E ane 2 columns vunnayi.
For a give A, I need to get B, E.
I should get E only when C ='x', if C is not 'x' or there is nor record for A in table 2, E should be blank.
ela rayaali query?
select B, E from 1,2,3 where A = 'Given vlaue' and C = 'x' and 1.A = 2.A(+) and 2.D = 3.D
ani rasaanu, when C != 'x' I am not getting no records back, but still I need (B, null) back.
konchem light veyyandi..
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
|
Archives - 2016