| Author |
Message |
    
Gochi
Bewarse Legend
Username: Gochi
Post Number: 53492
Registered: 07-2004
Posted From: 70.44.12.14
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 6:08 pm: |    |
 |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7306
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 3:52 pm: | |
movies emi levu gaa....ee section ee bagundi ga movies daani meeda  |
Babu
Celebrity Bewarse
Username: Babu
Post Number: 13492
Registered: 06-2004
Posted From: 65.208.22.26
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 3:44 pm: | |
hemu pakka secsun lo banned aa
ikkada padindi thread 
babu garu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7305
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:22 pm: | |
yeh ardamaipoyindi...ippuud paid amount koda select cheyyali. ento jeevitham...fiscal years 07 and 08 ki kanukkovalanta vendors ki...okokkati select chesukunta vasthanna..ee roje kavali annaru daridrulu.. |
310
Pilla Bewarse
Username: 310
Post Number: 213
Registered: 12-2006
Posted From: 138.32.32.166
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:18 pm: | |
simple mama.. select clause lo non-aggregated column anni group by lo pettali... aggregated column petta kudadu anna mata  |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 16425
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:17 pm: | |
The great pleasure in life is doing what people say you cannot do |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7304
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:14 pm: | |
work avuthundi  thanks nayakesh....nuvvu ee db lo naa second fav after ON mama...3rd rattesh.... |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7303
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:13 pm: | |
hehe group by lo invoice_aount thesesa...run avuthundi...chodham... |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7302
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:10 pm: | |
SELECT pv.vendor_name,
sum(ai.invoice_amount) invoice_Due_amount
FROM ap_invoices ai,
po_vendors pv,
po_vendor_sites_all pvs
WHERE 1 = 1
AND ai.vendor_id = pv.vendor_id
and pv.vendor_id = pvs.vendor_id
AND TRUNC(SYSDATE) BETWEEN
pv.start_date_active AND NVL(pv.end_date_active, SYSDATE+1)
and pvs.vendor_site_code NOT IN ('TANDE')
and nvl(pv.enabled_flag, 'N') = 'Y'
and pv.end_date_active is null
and pvs.inactive_date is null
and pvs.pay_site_flag = 'Y'
AND ai.cancelled_date is null
AND nvl(ai.amount_paid, '0.00') = '0.00'
GROUP BY pv.vendor_name, ai.invoice_amount
ORDER BY pv.vendor_name |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7301
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:10 pm: | |
adee chesanu mama...ravatam ledu  |
310
Pilla Bewarse
Username: 310
Post Number: 212
Registered: 12-2006
Posted From: 138.32.32.166
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:07 pm: | |
select vendor_name, sum(Invoice_Amt)
from tbl
gorup by vendor_name |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 7300
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 17, 2008 - 2:05 pm: | |
nenu 2 columns select chesthunna..
Vendor_Name, Invoice_Amount
ayithe naaku vache data ila vasthundi
Vendorname, amount
AAAA 10
AAAA 20
kaani naku output ila ravali
Vendorname, amount
AAAA 30
nenu sum(amount) group by vendorname annanu. ayina work avvatam ledu. ekkada mistake chesthunna?? |
