SQL Query Help   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2009Cine Talk - Reviews, Gossips, Insider Info etc.Archive through January 25, 2009SQL Query Help Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8455
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:38 pm:Edit PostDelete PostView Post/Check IP


Gochi :

piccha fastgaa unnaavgaa hemesh




migilinavi PO issues..vendor bank setups etc gochesh..oka assalainadi undi..PO approval hierarcy, apporval limits, evadiki PO create chese rights unnay, evariki approve chese rights unnay...veetiki data pampanu internal auditors ki...aame evo 10 questions tho mail kottindi..ippudu andulo okokkati soodali.....
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8454
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:36 pm:Edit PostDelete PostView Post/Check IP


Racchamass :

ammani pipty miss




Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16882
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:33 pm:Edit PostDelete PostView Post/Check IP

ammani pipty miss
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57427
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:32 pm:Edit PostDelete PostView Post/Check IP

piccha fastgaa unnaavgaa hemesh


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8453
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:30 pm:Edit PostDelete PostView Post/Check IP



inka oka 3 tasks unnay anthe...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16880
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:30 pm:Edit PostDelete PostView Post/Check IP

49
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 4966
Registered: 09-2006
Posted From: 66.30.108.90

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 8:29 pm:Edit PostDelete PostView Post/Check IP

hemu ..
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16878
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:51 pm:Edit PostDelete PostView Post/Check IP

saala matter undi kada taadu lo
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8452
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:49 pm:Edit PostDelete PostView Post/Check IP

inka oka 12 tasks paina unnay cheyyalsinavi..ide intha time pattindi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8451
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:48 pm:Edit PostDelete PostView Post/Check IP

hmm...evaro kani bagane idea ichadu pivot ani...asala xls file ni ala soothante kannula pandaga ga undi..kiki. US and Canada vendors ki run chesi pampesa...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57422
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:40 pm:Edit PostDelete PostView Post/Check IP

emo ayyundocchu....IP soosthe georgia state soovisthaandhi


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8450
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:39 pm:Edit PostDelete PostView Post/Check IP

emo mari..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57421
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:38 pm:Edit PostDelete PostView Post/Check IP

inthaki ee gochidada evalu......


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8449
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:37 pm:Edit PostDelete PostView Post/Check IP

thanks beeresh for the basic query...thanks gochidada for the pivot query...thanks goches for the continous support and max help...kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57420
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:35 pm:Edit PostDelete PostView Post/Check IP

venjoyy.....



Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8448
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:33 pm:Edit PostDelete PostView Post/Check IP

run ayyindi gochesh..kiki..

SELECT Vname,
Vnum,
max(decode(payment_month, 'JUL-07', payment_amount, null)) "Jul-07",
max(decode(payment_month, 'AUG-07', payment_amount, null)) "AUG-07"
FROM (SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
to_char(ac.check_date, 'MON-YY') payment_month,
sum(aip.amount) Payment_Amount
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1,
to_char(ac.check_date, 'MON-YY')
order by to_char(ac.check_date, 'MON-YY'), pv.vendor_name)
group by VName, VNum
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8447
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:32 pm:Edit PostDelete PostView Post/Check IP

naaku problem ardamaindi..correct chesthunna..running query..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8446
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:21 pm:Edit PostDelete PostView Post/Check IP

exactly gochesh..alage vasthundi data..oh ardamaindi..kani max pedithe indaka ichina error vasthundi :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57419
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:12 pm:Edit PostDelete PostView Post/Check IP

without max neeku ee format lo raavali data....

ID, July, August,September
1,400,-,-
1,-,500,-
1,-,-,600

max pedithe instead of 3 rows,you should get max grouped by each ID

ID, July, August,September
1,400,500,600

ante blanks ni max tho filter chesthunnaavannamaata
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57418
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:10 pm:Edit PostDelete PostView Post/Check IP

group by date theesettey problem undadhu hemesh....endukante manam aa calucations anni select clause lo chesi by date line by line isthunnaam....

aina date theesesaaka kooda same error endhi varitygaa





Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8445
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:08 pm:Edit PostDelete PostView Post/Check IP

assala max enduku pettali???
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8444
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:06 pm:Edit PostDelete PostView Post/Check IP

emaindi chippesh...nenu ee query ki oka half day chesa ante gundelu badukuntaru company vaallu..kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8443
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:06 pm:Edit PostDelete PostView Post/Check IP

same error..kani group by thesesthee assala beeresh ichindi raademo ga...ayina group by lo date di thesesina same error :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow

Post Number: 4774
Registered: 05-2008
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:04 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57417
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:03 pm:Edit PostDelete PostView Post/Check IP

emantaandhi ippudu
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8442
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:03 pm:Edit PostDelete PostView Post/Check IP

sesa gochesh...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57416
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:02 pm:Edit PostDelete PostView Post/Check IP

kinda group by lo date theesesaa...try this

SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07"
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1
order by pv.vendor_name
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8441
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 7:01 pm:Edit PostDelete PostView Post/Check IP

SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07"
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1,
to_char(ac.check_date, 'MON-YY')
order by pv.vendor_name
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57415
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:58 pm:Edit PostDelete PostView Post/Check IP

kindha group by add seyyu migathaa columns ki (columns not having max in select clause)....
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8440
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:56 pm:Edit PostDelete PostView Post/Check IP


Gochi :

alaa aithe mundu oka max padeyyi




not a single group group functionantundi max add chesthe..


ORA-00937 not a single-group group function

Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.

Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8439
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:54 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow

Post Number: 4773
Registered: 05-2008
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:49 pm:Edit PostDelete PostView Post/Check IP

aythey ee work ki nuvvu chese billing lo 50% db ki kattu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57414
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:49 pm:Edit PostDelete PostView Post/Check IP

alaa aithe mundu oka max padeyyi....decode and case statement are exactly the same....

max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8438
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:47 pm:Edit PostDelete PostView Post/Check IP


Shadow :

Bemmam db valla chetha work seyichhavantey na




em seyyanu mama...3 days postpone sesaa query dorakka..query dorikaka ee problem :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8437
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:46 pm:Edit PostDelete PostView Post/Check IP

Idi work ayyindi gochesh..

decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount)) "Jul-07",

just 2 months ki try chesa...

vendor1 ki 2 rows vachi okokka row lo okokka month ki display avuthunnay values...so adi correct cheyyali...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57413
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:44 pm:Edit PostDelete PostView Post/Check IP

shado baa


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow

Post Number: 4772
Registered: 05-2008
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:42 pm:Edit PostDelete PostView Post/Check IP

Bemmam db valla chetha work seyichhavantey na
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57412
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:33 pm:Edit PostDelete PostView Post/Check IP

select
max(case when (year(payment_date) = 2007 and month(payment_date) = 07) then sum(payment)) "July-07",

idhi try chesi choodu....
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8436
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:33 pm:Edit PostDelete PostView Post/Check IP

ippudu endo missing keywork antundi..sare chostha aagu..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8435
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:28 pm:Edit PostDelete PostView Post/Check IP


Gochi :

select
max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07",
max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07",
etc etc...

ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi




invalid relational operator = antundi...tochar annamana endi??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57411
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:26 pm:Edit PostDelete PostView Post/Check IP

Registered: 01-2007

eppudo register sesukuni after 2yrs ippudu postings settunnaava gochidada


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57410
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:21 pm:Edit PostDelete PostView Post/Check IP

select
max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07",
max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07",
etc etc...

ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 57409
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:15 pm:Edit PostDelete PostView Post/Check IP

eee gochidada evalu


Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of pageLink to this message

Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow

Post Number: 4771
Registered: 05-2008
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:13 pm:Edit PostDelete PostView Post/Check IP

>>If you want to know more about it, there is this website called www.google.com

Top of pagePrevious messageNext messageBottom of pageLink to this message

Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow

Post Number: 4770
Registered: 05-2008
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:12 pm:Edit PostDelete PostView Post/Check IP

Gochidada, olu nuvvu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochidada
Pilla Bewarse
Username: Gochidada

Post Number: 4
Registered: 01-2007
Posted From: 67.159.44.138

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:10 pm:Edit PostDelete PostView Post/Check IP

Pivot query is just a way of cheating regular query to get the desired output in column format. google it and you will see many examples.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochidada
Pilla Bewarse
Username: Gochidada

Post Number: 3
Registered: 01-2007
Posted From: 67.159.44.138

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:08 pm:Edit PostDelete PostView Post/Check IP

you have to use pivot query to see column wise output.
If you want to know more about it, there is this website called www.google.com
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8434
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:07 pm:Edit PostDelete PostView Post/Check IP


Gochidada :

you have to use pivot query to see column wise output




idendi...????
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8433
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 6:00 pm:Edit PostDelete PostView Post/Check IP

bagane work avuthundi kaani rows lo vasthundi...:-) thanks beeresh...:-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8432
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 5:53 pm:Edit PostDelete PostView Post/Check IP

beeresh...aagu sootha...nenu inka each month ki ichi payment_date between ani save cheshunna file ni
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochidada
Pilla Bewarse
Username: Gochidada

Post Number: 1
Registered: 01-2007
Posted From: 67.159.44.138

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 5:50 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :



wonder what is your job title ,your billing rate, years you have been working here
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 4965
Registered: 09-2006
Posted From: 66.30.108.90

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 5:50 pm:Edit PostDelete PostView Post/Check IP

select to_char(payment_date, 'MON-YY'), sum(payment)
from table
group by to_char(payment_date, 'MON-YY')
order by to_char(payment_date, 'MON-YY')
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8431
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, January 11, 2009 - 5:35 pm:Edit PostDelete PostView Post/Check IP

payment_date month ni batti sum chesi different months ki rastham elagu??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8430
Registered: 06-2004
Posted From: 65.196.167.82

Rating:
Votes: 1(Vote!)

Posted on Sunday, January 11, 2009 - 5:30 pm:Edit PostDelete PostView Post/Check IP

Vendor payments ki query raayali..Jul-07 to Dec-08 varaku..

oka month lo vendor ki chala invoices payment untundi..like Jul-07 lo oka 20 invoices(with different payment dates) untay..ippudu emi data kaavali ante..

Vendor_name Jul-07 Payment, Aug-07Payment, Sep-07 Payment,.....


each month ki sum chesi raavali query...elaa raayali adi??