| Author |
Message |
    
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3034
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 4:52 pm: |    |
>M lodhi ippude nenoka thaadeddam anukunna SQL help ani..soosesariki hemanthgadu esi D'du...>
VEERABHADRA |
Singa_malai
Kurra Bewarse
Username: Singa_malai
Post Number: 681
Registered: 07-2005
Posted From: 70.36.27.97
| | Posted on Tuesday, April 18, 2006 - 4:14 pm: | |
eppudoo YELP theesukovadamey naa YEMU maayaaa..
Leecher type anna maata ayithey nuvvu....
 |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15065
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 4:11 pm: | |
neni ide naa modati thadu and post mama iyyala anni DB laloki.  picha busy ga unnanu. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19158
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, April 18, 2006 - 3:51 pm: | |
 M lodhi ippude nenoka thaadeddam anukunna SQL help ani..soosesariki hemanthgadu esi D'du... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19156
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, April 18, 2006 - 3:49 pm: | |
 |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3025
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 3:23 pm: | |
VEERABHADRA |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15064
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:20 pm: | |
nayakudu mama. 
 |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15063
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:17 pm: | |
yeh, pani sesindi, naa valla kavatam laa anandam thattukovatam. kiki.
Thanks nayakudu mamoi. kiki.
agu xls loki laagi mail sesi vatha. kiki. |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3021
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 3:15 pm: | |
yaaa sarigga seyei,vachetadi..
VEERABHADRA |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15062
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:14 pm: | |
mamoi, pani sesindi kaani. thappu data vachindi, kani nee format pani sesindi. kiki, query marcha. pani sethe bagundu, demudaaaaa. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2831
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 3:12 pm: | |
work ayyiddile... |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2830
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 3:11 pm: | |
jkadu mama group by 1 anaku.. actual column ivvu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15061
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:11 pm: | |
KIKI. 1 thesesi period_name anna, execute avuthundi. kiki. work ayithe bagundu demudaa, inti nunchi working iyyala, oka manager, director lu phone sesi security audit, data kavali annaru. manaki pichalu pack. kiki. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2829
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 3:09 pm: | |
group by lo
gjh.je_header_id, gjl.je_header_id
gjl.code_combination_id, gcc.code_combination_id kuda add chesi chudu |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3019
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 3:07 pm: | |
kikiki marri nuvvu kooda help seyei velu ayeinantha kudirinappudu
VEERABHADRA |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2828
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 3:07 pm: | |
mama cheyyu..
iraga rasavu ga query asalu...
gjl.je_header_id , gcc.code_combination_id fields meeda index vunnayi anukuntunna.. fast gane avvali mari alage |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15060
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:06 pm: | |
bob maaya, yeh, mana db lo saana mandi helping setharu maaya, ekkuva help thesukonedi nene. kiki. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15059
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:05 pm: | |
not a group by expression anta. |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3018
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 3:05 pm: | |
etta okko technology okkallu untey entha bagundu..
okalki okallu help chesukontey antha happy mayam..
bewarse lu u
help sesukovatam lo mana db taruvatha e db ayeinaa...
VEERABHADRA |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15058
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:04 pm: | |
mama execute seyyana, saana time paduthundemo, anduke mundu aduguthunna ok kada ani. kiki. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15057
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:04 pm: | |
select gjl.period_name, count(gjl.je_line_num)
FROM gl_je_headers gjh,
gl_je_lines gjl,
gl_code_combinations_kfv gcc
WHERE gjh.je_header_id = gjl.je_header_id
AND gjl.code_combination_id = gcc.code_combination_id
AND gjh.set_of_books_id = 1
AND gjl.period_name >= 'JUN-05'
AND gjl.period_name <= 'MAR-06'
AND gcc.segment1 IN ('0187', '0170', '0112')
group by 1 |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15056
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 3:00 pm: | |
Thanks mama, aagu chosthunna. 
nuvvu lekapothe emaipoye vallamo mama. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2827
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 2:57 pm: | |
timestamp vunte trunc use cheyyu
select trunc(dt_column), count(*) fro table
group by trunc(dt_column) |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 2826
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, April 18, 2006 - 2:57 pm: | |
select dt_column, count(*) from table
group by dt_column |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3014
Registered: 03-2005
Posted From: 70.16.21.147
| | Posted on Tuesday, April 18, 2006 - 2:56 pm: | |
nayukudu mama
VEERABHADRA |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15055
Registered: 03-2004
Posted From: 24.136.224.61
| | Posted on Tuesday, April 18, 2006 - 2:54 pm: | |
mamalu,
naaku oka tableundi, andulo oka column value jun-5, jul-05, ..mar-06 varaku untundi.
ippdudu nenu emi kanukkovalante jun-05 ani unna lines enni, jul-05 ki unna lines enni,.. ala until mar-06 varaku. single query tho sadhyam avuthunda mamalu?? |
