Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2012 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through June 20, 2012 * Oracle SQL Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Royal1234
Pilla Bewarse
Username: Royal1234

Post Number: 984
Registered: 08-2010

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

Posted on Tuesday, June 19, 2012 - 1:12 pm:    Edit Post Delete Post Print Post


Sasibabu:

eyyy...Ongolia




Icon super set ayenid annai. closed door lungi/pillows/lady :-)
http://i40.tinypic.com/hwg38o.png
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8557
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 12:54 pm:    Edit Post Delete Post Print Post


Royal1234:


eyyy...Ongolian MOVIEART--bemmi.lungi
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Royal1234
Pilla Bewarse
Username: Royal1234

Post Number: 983
Registered: 08-2010

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

Posted on Tuesday, June 19, 2012 - 12:48 pm:    Edit Post Delete Post Print Post

Gali annai ,experts lera ee field lo . next time nundi edo oka filed experts aytey ID approve ceyandi

Sasi annai nee raging MOVIEART--bemmi.laugh
http://i40.tinypic.com/hwg38o.png
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8556
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 11:42 am:    Edit Post Delete Post Print Post


Ravanabrahma:

adi try chesthunna..work ayyidhemo cheptha aagu


avasarledhule maayya ....even stewie kooda antha kuthuhalam gaa emi leduMOVIEART--bemmi.ok
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20054
Registered: 06-2004

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

Posted on Tuesday, June 19, 2012 - 11:32 am:    Edit Post Delete Post Print Post


Stewie:




with command not supported baa ee report builder lo..edo pipeline function undi as workaround. adi try chesthunna..work ayyidhemo cheptha aagu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8555
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 11:29 am:    Edit Post Delete Post Print Post


Ravanabrahma:

lekapothe mee idharini oka araganta ban sesevadini


ee db emanna mee M babu pans jageeraa maayyya MOVIEART--bemmi.madatha
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20053
Registered: 06-2004

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

Posted on Tuesday, June 19, 2012 - 11:23 am:    Edit Post Delete Post Print Post

naa cop password pani cheyyatam la. lekapothe mee idharini oka araganta ban sesevadini CLIPART--angry
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Mudiripoyina Bewarse
Username: Dobbey

Post Number: 12240
Registered: 12-2009

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

Posted on Tuesday, June 19, 2012 - 10:58 am:    Edit Post Delete Post Print Post


Sasibabu:

so table lo sivarakari rendu sthaanalu babu vi


MOVIEART--venky.ya
CLIPART--bananamac
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Mudiripoyina Bewarse
Username: Dobbey

Post Number: 12239
Registered: 12-2009

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

Posted on Tuesday, June 19, 2012 - 10:58 am:    Edit Post Delete Post Print Post


Ravanabrahma:

mee nasa endi madhyalo. avathalaki pondi.




nuvvvu kochens adigaaav.. naa kochen ki samadhanam cheppu maayya MOVIEART--avataram
CLIPART--bananamac
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20052
Registered: 06-2004

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

Posted on Tuesday, June 19, 2012 - 8:28 am:    Edit Post Delete Post Print Post


Dobbey:



Sasibabu:




mee nasa endi madhyalo. avathalaki pondi. CLIPART--arme3
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20051
Registered: 06-2004

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

Posted on Tuesday, June 19, 2012 - 8:25 am:    Edit Post Delete Post Print Post


Stewie:

With command try cheyyandi. ..ravachu emo




with command work ayyindi kaani query ki vaadi rdf lo unchithe error vasthundi iteration ani. so chosthunna :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8552
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 12:13 am:    Edit Post Delete Post Print Post


Dobbey:


bizinessman dookudu ni kottindhi, Dammu Bizinessman ni kottindhi, racha dammu ni kottindhi, Gabbar singh racha ni kottindhi.....so table lo sivarakari rendu sthaanalu babu vi MOVIEART--bemmi.ok
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8551
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 12:10 am:    Edit Post Delete Post Print Post


Dobbey:


aaku mukkana egiregiri kottindhi
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Mudiripoyina Bewarse
Username: Dobbey

Post Number: 12238
Registered: 12-2009

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

Posted on Tuesday, June 19, 2012 - 12:09 am:    Edit Post Delete Post Print Post

Dookudu ni gabbarsingh kotindaa??
CLIPART--bananamac
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

Post Number: 8549
Registered: 10-2010

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

Posted on Tuesday, June 19, 2012 - 12:07 am:    Edit Post Delete Post Print Post

thed lo 7 posts....andhulo 6 posts maayya vi ..... ee 6 lo 1 question dhaaniki 5 answers aayane... battinguu aayane, bowlinguu aayane, fieldinguu, umpiringuu aayane .... nenu stewie stadium avathala chettu meedhaki ekki soothunna byatchee MOVIEART--bemmi.frock
Jai Tara ,Jai Jai JujubiAnna
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Kurra Bewarse
Username: Stewie

Post Number: 1713
Registered: 03-2011

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

Posted on Monday, June 18, 2012 - 10:25 pm:    Edit Post Delete Post Print Post

With command try cheyyandi. ..ravachu emo
Patha Signature teeseysa
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20050
Registered: 06-2004

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

Posted on Monday, June 18, 2012 - 10:16 pm:    Edit Post Delete Post Print Post

kakapothe test_debug anedi table kadu. adi koda pedda sql query. adi rendu chotla rayatam kanna simple method emundi query rasthaniki
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20049
Registered: 06-2004

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

Posted on Monday, June 18, 2012 - 10:11 pm:    Edit Post Delete Post Print Post

eyyy..raasesa..below query is working :-)


select * from test_debug a
where 1 = 1
and exists (select project_id
from test_debug b
where 1 = 1
and a.project_id = b.project_id
having sum(amount1) != 0 and sum(amount2) != 0
group by project_id)
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20048
Registered: 06-2004

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

Posted on Monday, June 18, 2012 - 10:08 pm:    Edit Post Delete Post Print Post

if I write the query like this, it is working good kaani I need other column names also in select that are not in group by. ela raayali?

select project_id
from table_name
where 1 = 1
having sum(amount1) = 0 and sum(amount2) = 0
group by project_id
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20047
Registered: 06-2004

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

Posted on Monday, June 18, 2012 - 9:53 pm:    Edit Post Delete Post Print Post

nenu ila rasanu query..

select project_id, amount1, amount2, line1, date
where 1 = 1
having sum(amount1) = 0 and sum(amount2) = 0
group by project_id annanu kaani adi remaining columns koda ivvali antundi..remaining columns group by lo isthe sum correct ga calculate avvadu as the line1, date column value are not same for the given project_id.

ela rayaali query?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 20046
Registered: 06-2004

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

Posted on Monday, June 18, 2012 - 9:49 pm:    Edit Post Delete Post Print Post

naaku oka query undi like...

select project_id, amount1, amount2, line1, date

ayithe vachina results lo if sum(amount1) = 0 and sum(amount2) = 0 for a particular project_id, then don't show those lines in the results. ela rayali query?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration