| Author |
Message |
    
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1986
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 3:10 pm: |    |
Gosi naa peru meed akuda raasi paara dobbu
Hook naa ??  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18650
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 2:49 pm: | |
 babugaa....ettagaina roju DB kocchi SQL diskasing sesukuni oka nelalo oracle certipication raasi D'lani andaram sketch geesaam... |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8227
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, April 10, 2006 - 2:41 pm: | |
ammo intha pedda thaada 
idi bewarse db anukunnava
sql db anukunnava gosi ga  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18648
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 2:17 pm: | |
 swarry...not exists ni exists gaa maristhe saripothundhi kadhaa...thanx again maayyas  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18645
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 2:09 pm: | |
OM,Nayak maayyas...meeru emi anukokapothe inkoka cinna kochen..
eee list of accounts ok...ippudu indulo lenivi kaavalante emi cheyyaali..ante idhi only eee rendu loss types unna accounts...oka vela ee rendu undi,inkaa emanna egestra losses unna accounts kaavalante elaaa... eee sql emanna modify cheyyacchaa easygaa..
SELECT DISTINCT a.Account, b.LossType
FROM Acc_Claim AS a, Loss AS b
WHERE b.LossType in ('TG', 'LK')
and a.Claim = b.Claim
and not exists (select 1 from Acc_Claim c, Loss d
where c.Claim = d.Claim
and a.Account = c.Account
and d.LossType not in ('TG', 'LK')); |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18644
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 1:59 pm: | |
thanx OM maama....idhi work ayyindhi...
thanx Nayakudu maama...opigga nenicchina thokkalo requirementski manchi SQL raasinanduku  |
Okka_magaadu
Pilla Bewarse
Username: Okka_magaadu
Post Number: 54
Registered: 04-2004
Posted From: 157.91.44.1
| | Posted on Monday, April 10, 2006 - 1:46 pm: | |
Idi Tru chey vasthundemo
SELECT DISTINCT a.Account, b.LossType
FROM Acc_Claim AS a, Loss AS b
WHERE b.LossType in ('TG', 'LK')
and a.Claim = b.Claim
and not exists (select 1 from Acc_Claim c, Loss d
where c.Claim = d.Claim
and a.Account = c.Account
and d.LossType not in ('TG', 'LK')); |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2490
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 1:43 pm: | |
H1B meeda lenu.. L1 meeda vunna...
ippudu jump le inka |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18643
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 1:42 pm: | |
 naaku kooda nelaki 3500 kante raadhu taxulu poyaaka...madhyalo consultants baane dobbuthaaru paisalu |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1983
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 1:41 pm: | |
H1 meeda untee jump ayipooo
 |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1982
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 1:40 pm: | |
 ammo TCS aaa |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2488
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 1:33 pm: | |
80 USD na naluka thadaruthundi... ante 14k / month
hehehe
ee TCS kode gallu
nelaki 3800 lo chethilo peduthunnaru mama |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1981
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 1:31 pm: | |
nenu ETL informatica
brio kuda chestha.. datastage billing ela vundi amam... informatica ela vundi.
teliyadhu mama
nenu QA loo unnanu ..
konni places loo 75 -80 per hour undi mama |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2487
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 1:30 pm: | |
gudiwada mama
daa
nenu ETL informatica
brio kuda chestha.. datastage billing ela vundi amam... informatica ela vundi... |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1980
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 1:29 pm: | |
Seema gochi ki kaneellu emiti
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18642
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 1:27 pm: | |
 |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1979
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 1:25 pm: | |
nenu DW reporting side...nuvvu dentlo
nenu DW ETL side
nenu etl datastage loo unnanu
we are family annamata |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2481
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 1:22 pm: | |
hehehehe
GODFATHER lo mikey dialogue laga
don't tell me it is not working... it insults my intelligence..
gochi mama next ninnu car lo champatame
hehehe |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2479
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 1:18 pm: | |
appudu work ayyiddi chudu kinda ichhindi
bau alage execute cheyyi danni customize cheyyaku |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18641
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 1:17 pm: | |
aunu maama....t1 to t2 one to many, claim no is unique |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2478
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 1:16 pm: | |
babu t1, t2 ki madhya type of relationship enti...
one to many na...
t1 lo claim_no unique naa |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2477
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 1:15 pm: | |
babu gochi exact same execute cheyyi
select t1.account_no,
count(distinct decode(t2.loss_type, 'LG', '1', 'TG', '1', '2')),
count(distinct
case WHEN t2.loss_type not in ('LG', 'TG') THEN '2' END)
from t1,
t2
where t1.claim_no = t2.claim_no
group by
t1.account_no
having count(distinct decode(t2.loss_type, 'LG', '1', 'TG', '1', '2')) = 1
AND count(distinct
case WHEN t2.loss_type not in ('LG', 'TG') THEN '2' END) = 0 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18640
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 1:09 pm: | |
mayyas...meeru cheppindhi correstgaa work avuthundhi for the case that all information is in one table... naa problem entante
account_no,
claim_no
ee rendu oka table t1 lo unnayi...
claim_no,loss Type,office
evanni inko table t2 lo edisaayi...
so nenippudu,
select t1.account_no,
t1.claim_no,
t2.loss_type
from t1,
t2
where t1.claim_no = t2.claim_no
and t2.loss_type in ('LG','TG')
and not exists ( select 'X' from t22 where t22.claim_no = t2.claim_no and loss_type not in ('LG','TG'))
ani raasthe raatalledhu...it is picking up all the accounts again... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2476
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 12:52 pm: | |
gochi mama nenu kinda values ichha..
aa case lo only 1 ne vachhiddi mari naku aa query tho.. neevu yemi chesthunnavo asalu..
aa query ikkada paste cheyyi |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2475
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 12:50 pm: | |
OM mama query use cheyyu work ayyiddi |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18639
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:48 pm: | |
maama...
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1
AND count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END) = 0
ilaaa raasthey raatalledhu maayya....for example oka caselo LG,MG unna kooda adhi return avuthondhi  |
Okka_magaadu
Pilla Bewarse
Username: Okka_magaadu
Post Number: 53
Registered: 04-2004
Posted From: 157.91.44.1
| | Posted on Monday, April 10, 2006 - 12:42 pm: | |
Inthaku vachindaa? Last lo ')' miss ayyaa and "from" two times ichhaa????? |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2474
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 12:39 pm: | |
OM mama
iraga kumavu ga |
Okka_magaadu
Pilla Bewarse
Username: Okka_magaadu
Post Number: 52
Registered: 04-2004
Posted From: 157.91.44.1
| | Posted on Monday, April 10, 2006 - 12:37 pm: | |
I think this might work if either of 'TG' or 'LK' is required and no other losstypes must be there.
select distinct account, losstype
from losstable t1
where t1.losstype in ('tg', 'lk')
and not exists (select 1 from losstable t2
from losstable t2
and t1.account = t2.account
and t2.losstype not in ('tg', 'lk') |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2471
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 12:21 pm: | |
inko condition add chesa... case ani... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18638
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:21 pm: | |
 mari naakenduku kaavalsina output kaakundaa anthaku mundara vacchina same output vasthondhi...inkemanna conditions dobbinayyemo choosthaa undu.... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18637
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:15 pm: | |
 avunu maama....undu malli try chesi chepthaa |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2469
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 12:09 pm: | |
only TG or
only LG or
only TG or LG
vunn account ravali kada... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2468
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 12:08 pm: | |
select act_type, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')),
count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END)
from test123
group by act_type
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1
AND count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END) = 0
idi 1 return chesindi mari |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18636
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:07 pm: | |
adenti |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2467
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 12:07 pm: | |
ala values vunte only 1 ravali kada output lo.. anthena..
mari work avuthundi kada |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2466
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 12:06 pm: | |
1 TG
1 TG
1 LG
1 TG
2 TG
2 LL
3 LG
3 LK
4 TG
4 LG
4 LL
4 LK |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18635
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:03 pm: | |
 ledhu maama...same output vacchindhi malli |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2465
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 12:00 pm: | |
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')),
count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END)
from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1
AND count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END) = 0
idi work ayyindaa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18634
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 12:00 pm: | |
 move chesey badulu same date column inkoti petti D'gu...mappingki oka link kalipi dobbu ekkadnuncho |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2464
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:56 am: | |
hehehe vadi daggaraiki vellali.. ela move cheyyamantado |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2463
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:56 am: | |
enti move chesedi naa M... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2462
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:55 am: | |
nenu DW ETL side |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2461
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:54 am: | |
gosi mama chakkaga design chesa... rqmnts annitini cover chesa... vallu firstlo cheppinatte tables design chesa... SP' anni rasa.. mappings design chesa... ippudu vachhi... dates inko table loki move cheyyi antunnaru.. chiraku dthundi..
hehehe |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18633
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:53 am: | |
gudi maama...nenu DW reporting side...nuvvu dentlo |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2460
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:53 am: | |
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')),
count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END)
from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1
AND count(distinct
case WHEN losstype not in ('LG', 'TG') THEN '2' END) = 0
idi try cheyyu |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1978
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 11:51 am: | |
mee eddaru work chesedhi oracle loo naa leka DW loo naa
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18632
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:49 am: | |
support vallu naa DLD review chesedi endi thokka gallu
 support vaadidhem poindhi...etta badithe atta tables D'chukomantaadu...attaaa eeda design seyyalante oka iravai snowplake schemalu,muppai start schemaala lekkana thayaravuddi database... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2459
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 11:49 am: | |
hehehe GOCDHI mama |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1977
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 11:48 am: | |
detail level design mama... development perspective lo design chesthara lepothey support perspectiv elo design chesthara... support vallu naa DLD review chesedi endi thokka gallu
Avunaa
ee darun hi |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1976
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 11:47 am: | |
nannu cheppamantaava gochi mama  |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2458
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:46 am: | |
detail level design mama... development perspective lo design chesthara lepothey support perspectiv elo design chesthara... support vallu naa DLD review chesedi endi thokka gallu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18631
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:46 am: | |
atta annaaa kooda malli records anni vachesthunnayi...ento deenemma.. having and pettina kooda adhedho where losstype in ('LG', 'TG') annattu pariganinchi dobbey mannadhi...malla ekkadekkadaithe LG,TG unnayo anni accounts dobbinchukunnayi.. |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1975
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 11:44 am: | |
DLD ante emiti ?? |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2457
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:44 am: | |
hehehe ee query kuda work kadu... anukunta
hehehe |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2456
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:41 am: | |
select * from table1 where account in (
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1 ) and
losstype in ('LG', 'TG')
anu |
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 114
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Monday, April 10, 2006 - 11:40 am: | |
ante mama job lu anni india ke ga
ikkada janam takkuva |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18630
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:39 am: | |
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1
maama ...idhi kooda work avvatledhu...endukante distinct annappudu 1 okkate count cheyyadu kadhaa...2 kooda count avuthundhi...so 2 okkatey unna kooda output loki vasthundhi...
count( distinct 2) = 1 kadhaa  |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2455
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:38 am: | |
eedini eppudo kani andari mundu book chesi d'li/.. hehe appudu kani matladakunda vundadu |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2454
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:38 am: | |
malla support ki off-shore lo iddaru... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2453
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:37 am: | |
M gallu support lo ekkuva mandi chachharu development lo kanna... 2 developers, oka manager, oka BA...
development lo oka developer, oka tech dummy lead... chi chi |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2452
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:34 am: | |
mama ikkada oka desi gadunnadu permanent employe.. naa M gadu pedda pistha anukuntadu... naa DLD ni marchu antunnadu.. dnegeha puka andam anukunna gani.. client ani vurukunna...
prathi dantlo elu pedathadu pedda puxku gadilaga...
naa M lodi DLD lo eedu support perspetive lo alochinhi.. rendu rojulu run kakapothey job ela... nenu ela re-run cheyyali ani.. naa M gadu... ippudu malla inko table petti d'chukovalai.. maa thalla client nemo dummy... ame yemi matladadu.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18629
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:30 am: | |
undu try chesi choosthaa |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2450
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:10 am: | |
hehehe nenu erra bussu gadini... gosi mamani nenu enduku anta... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2449
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:09 am: | |
mma correct idi
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1', '2')) = 1 |
Donga_evaru
Bewarse ke Bewarse!
Username: Donga_evaru
Post Number: 15022
Registered: 08-2004
Posted From: 134.130.245.46
| | Posted on Monday, April 10, 2006 - 11:09 am: | |
nayakudu mama gosi okate rendu posts vesthe kani ardham sesukoni yerra buss gadu anukunnava  |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2448
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:08 am: | |
mama
>>select account from table1
where losstype = 'TG'
group by account
having count(distinct losstype) = 1
ila rayakudadu.. appudu neeku eppudu TG vunna oka account ki adi vachhesiddi.. where clause mundu apply ayyiddi tharuvatha aa result set meeda group by apply ayyiddi |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2447
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:07 am: | |
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1')) from table1
group by account
having count(distinct decode(losstype, 'LG', '1', 'TG', '1')) = 1 |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2446
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, April 10, 2006 - 11:07 am: | |
mama here we go
select account, count(distinct decode(losstype, 'LG', '1', 'TG', '1') from table1
group by account
having count(distinct losstype) = 1 |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2445
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 11:04 am: | |
ammani... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2444
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 11:03 am: | |
enti ??? confuse ga vundi...
appudu 02341 kuda vachhiddi gada output lo... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18628
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 11:02 am: | |
maama...
select account from table1
where losstype = 'TG'
group by account
having count(distinct losstype) = 1
idhi baagane work avuthundhi...
kaani
select account from table1
where losstype in('TG','LG')
group by account
having count(distinct losstype) = 2
ante work avvadhu endukante its looking for either of TG/LG counts it as 1 and if the same account has some other loss type FG it counts as 2 and it returns the result..
so ala raakooodadhu... TG okkatunna raavali, LG okkatunna raavali...TG,LG rendu unna raavali... |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1974
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Monday, April 10, 2006 - 11:01 am: | |
Naaku telsu kaani nenu Seppanu gochi |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2443
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 11:01 am: | |
select * from table1 where account in (
select account, count(distinct losstype) from table1
group by account
having count(distinct losstype) = 1)
and losstype in ('va11', 'val2') |
Donga_evaru
Bewarse ke Bewarse!
Username: Donga_evaru
Post Number: 15016
Registered: 08-2004
Posted From: 134.130.245.46
| | Posted on Monday, April 10, 2006 - 11:00 am: | |
nayakudu mama
accounts having losstype TG and LK(should contain both) ravali
nuvvu cheppindhi okadhanike kadha |
Donga_evaru
Bewarse ke Bewarse!
Username: Donga_evaru
Post Number: 15015
Registered: 08-2004
Posted From: 134.130.245.46
| | Posted on Monday, April 10, 2006 - 10:58 am: | |
rendodhi yela include seyyalo ardham kaka malli kochening marchava gosiga |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2442
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 10:58 am: | |
naku ardham kaledu mama |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18627
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 10:56 am: | |
swarry maayya...sarigga cheppinattu lenu nenu
actualgaa ilaa naaku rendu loss types ki kaavali...like I want all the accounts having losstypes TG,LK... ante ee rendu maatrame undaali..egjample ki okkatani cheppaanu.. |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2441
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 10:55 am: | |
only account ---
select account from table1
group by account
having count(distinct losstype) = 1 |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2440
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Monday, April 10, 2006 - 10:54 am: | |
select account, count(distinct losstype) from table1
group by account
having count(distinct losstype) = 1 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18625
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, April 10, 2006 - 10:47 am: | |
maayyas...maa dataabselo oka table undi
Account,Claim,loss type,Office columns unnayi..
for each account there can be multiple claims/loss type/office
But the combination of claim-losstype-office is unique.
so ippudu for egjample :
Account, Claim, Losstype, Office
02341,12541,TG,YHK
02341,12542,JK,YHK
02341,12543,LK,YHK
02342,14521,TG,YHK
02343,14561,TG,YHK
so ilaa data unnappudu naaku all the accounts with losstype TG maatrame kaavali...ante only TG undaali aa account ki...so output ilaa raavali..
02342,
02343
02341 raakoodadhu,endukante daaniki TG tho paatu migathaa losses kooda unnayi
elaa seyyaali |
