| Author |
Message |
    
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6069
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 4:16 pm: |    |
bagane unna mama. konchem busy ga unna.  nuvvela unnav mama  |
Chonga
Yavvanam Kaatesina Bewarse
Username: Chonga
Post Number: 2992
Registered: 12-2004
Posted From: 64.154.62.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:54 pm: | |
ok.
intaki etlundaavu babai ?? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6068
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:51 pm: | |
rendu states satisfy ayina oka row chaalu mama. endukante renditlonu same info select chesthunna final ga. like employee number, expensereport number, amount. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6067
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:49 pm: | |
chonga mama, nuvvu cheppindi right I want only those state(13) rows but that expense report should have both the states 4 and 13.
basic ga 13 = submitted for audit approval
4 = receipt matching completed. |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 15126
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:31 pm: | |
union kaka inka emi use seyyalemu anukunta mama...
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Chonga
Yavvanam Kaatesina Bewarse
Username: Chonga
Post Number: 2988
Registered: 12-2004
Posted From: 64.154.62.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:26 pm: | |
i don't know much sql....but i guess it works |
Chonga
Yavvanam Kaatesina Bewarse
Username: Chonga
Post Number: 2987
Registered: 12-2004
Posted From: 64.154.62.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:26 pm: | |
performance baaleka poyinaa idi simple kadaa ??
select ..
from document d
where d.stateid = '13'
and exists (select 1 from
document d1
where d.documentnumber = d1.documentnumber
and d1.stateid = 4)
UNION
select ..
from document d
where d.stateid = '4'
and exists (select 1 from
document d1
where d.documentnumber = d1.documentnumber
and d1.stateid = 13) |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 15123
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:15 pm: | |
yeah...2 rows raavu..only 13 info vastundhi 
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Chonga
Yavvanam Kaatesina Bewarse
Username: Chonga
Post Number: 2986
Registered: 12-2004
Posted From: 64.154.62.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:09 pm: | |
aa query '4' kooda satisfy ayina '13' unna rows maatrame ostundi....no '4' related info would show up. |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 15122
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:07 pm: | |
endhuku?
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Chonga
Yavvanam Kaatesina Bewarse
Username: Chonga
Post Number: 2985
Registered: 12-2004
Posted From: 64.154.62.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 3:04 pm: | |
>>bemmam maaya query work avvutundhi
avvadu mama... |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 15109
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 11:09 am: | |
420 mama...
bemmam maaya requirements ki neevu ichina query work avvadhu....nee query ki 4 or 13 edi unna result vastundhi...
bemmam maaya query work avvutundhi
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
420
Yavvanam Kaatesina Bewarse
Username: 420
Post Number: 3335
Registered: 12-2006
Posted From: 194.151.208.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, February 05, 2008 - 10:57 am: | |
Bemmi .. I do not think that query werks 
Kuku kukuku ..Ullike padaku , Peedave KaalipeNduku  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6066
Registered: 06-2004
Posted From: 24.181.242.161
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 5:33 pm: | |
maa office lo okathanu cheppadu..lunch chestha adiga. appudu cheppadu |
Drifter
Yavvanam Kaatesina Bewarse
Username: Drifter
Post Number: 3549
Registered: 09-2007
Posted From: 138.32.32.166
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 5:07 pm: | |
maa ittam |
Bignole
Mudiripoyina Bewarse
Username: Bignole
Post Number: 7673
Registered: 03-2004
Posted From: 161.225.1.12
Rating:
Votes: 2(Vote!) | | Posted on Monday, February 04, 2008 - 4:31 pm: | |
mari enduku adigaav
Lakshallo Okkadni ....Laksha mandhiki okkadini |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6065
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 2:27 pm: | |
adi work avvadu. idi work avuthundi .
select ..
from document d
where d.stateid = '13'
and exists (select 1 from
document d1
where d.documentnumber = d1.documentnumber
and d1.stateid = 4) |
420
Yavvanam Kaatesina Bewarse
Username: 420
Post Number: 3326
Registered: 12-2006
Posted From: 194.151.208.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 10:04 am: | |
select StateID , count(*) from ur_tits group by StateID having StateID in(4,13)
Beeeeemeeeee Check this
Kuku kukuku ..Ullike padaku , Peedave KaalipeNduku |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6064
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 9:38 am: | |
kaadu mama. just 4 and 13 stateid unna rows mathrame raavali.
ippudu data ila undanuko.
expensereport number stateid
1 4
2 9
3 13
rendu rows vasthay.
ippudu data ila undanuko
expensereport number stateid
1 4
2 9
appudu oka row vasthadi. kani ala oka row unte naaku aa data vadhu. ippudu elaa rayali query ni. |
420
Yavvanam Kaatesina Bewarse
Username: 420
Post Number: 3325
Registered: 12-2006
Posted From: 194.151.208.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 9:28 am: | |
Bemme Bedar .. are you saying you want the 4rows ..and in those rows if the value of STATEID column is other than 4 and 13 u want to display Null ..
Use case statement in SQL if its oracle
Kuku kukuku ..Ullike padaku , Peedave KaalipeNduku |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6063
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, February 04, 2008 - 9:10 am: | |
oka table lo oka expense report number ki 4 rows unnayi. andulo stateid ane column value 4 and 13 rendu ayithene data return cheyyali ante aa 2 rows raavali annamata. ela rayali query  |
