| Author |
Message |
    
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5255
Registered: 06-2004
Posted From: 75.138.152.117
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:58 pm: |    |
nenu aa 3 columns ee kakunda inka chala select chesthunna mama like currency, check date etc. avanni group by lo unnayi. |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1399
Registered: 12-2005
Posted From: 76.179.8.89
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:57 pm: | |
group by vendor_name,check_number ivvavachu gaa ...rendu ichina problem ledu ga |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5254
Registered: 06-2004
Posted From: 75.138.152.117
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:55 pm: | |
select lo ememi unnavo avanni group by lo lekapothe error isthundi mama  |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1398
Registered: 12-2005
Posted From: 76.179.8.89
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:53 pm: | |
sorry order by kaadu group by
verevi teseyaloo ledoo naku teledu mari....nuvvu first adigina output ki aythe ala cheste saripothundi..
group by check number ...leka pothe ..group by vendor_name chesavu anukoo...same check_number or vendor_name vunna vi oka group avuthayi sum(amount) use cheste aa group lo anni ammounts sum avuthayi.....final ga neku kavalisina output vastundi} |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5253
Registered: 06-2004
Posted From: 75.138.152.117
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:47 pm: | |
order by chala unnayi. avanni thesesi only checknumber pettala mama?? repu chestha ayithe  |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1397
Registered: 12-2005
Posted From: 76.179.8.89
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 8:33 pm: | |
select vendor_name, check_number,sum(amount)
..............order by check_number;
edi work avvavachu maximum ..try cheyyi} |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5247
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 6:29 pm: | |
ravatam ledu mama, ade amount untundi pakka column lo. ippatike saana analyse sesa anukoni alage pampinchedham anukuntunna. aade total koodukuntadu le ani. kiki. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 48624
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 6:23 pm: | |
select vendor_name, check_number,sum(amount)
ani kodithe vachesthundi hemesh |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5245
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, October 10, 2007 - 6:10 pm: | |
ippudu vendor_name, check_number, amount unnayi columns
amount anedi check lo unna each item. (where condition lo unna conditions tho daanni thesuku vasthunna) so total check amount anedi each amount ni koodithe vache daniki equal avvalani ledu annamata.
ayithe ippudu naaku data ela vasthundi ante...
vendor_name check_number amount
1 100 10.00
1 100 20.00
1 100 30.00
2 101 10.00
2 101 20.00
kaani naaku ela ravalante
vendor_name check_number amount
1 100 60
2 101 30
ani ravali. elaa?? |
