Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2016 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through August 24, 2016 * SQL help.... < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:    Edit Post Delete Post Print Post

Onlymovies..Bro..Did you resolve this?

What SQL are you using?

SQL Server or any other?
Bezawada Bewarse Batchey
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


Proofdada:


nee dashu, copy paste kaadu logic ardham chesukuni step by steppe rasaanu..
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


Onlymovies:

Thanks bhayya, finally got it...


copy paste cheesi names change cheesava MOVIEART--bemmi.angry1... ittantivi step by step try chesukuntu povali with google help, then you will learn it, leepothe rocket science la vuntadhi eppadiki. MOVIEART--avataram
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


Symbol_of_king:


Thanks bhayya, finally got it...
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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(+)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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?
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


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...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

Idhi saana visy ga om bha...perf pakkanedithe ettagayina rasukovachu ee stmt nu...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


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...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post


Symbol_of_king:


Thanks bhayya, will try.
Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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...

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration