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 - 2014 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 05, 2014 * Oka simple query(sql) < Previous Next >

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

Ferrari
Mudiripoyina Bewarse
Username: Ferrari

Post Number: 10665
Registered: 09-2010
Posted From: 207.173.232.98

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

Posted on Friday, February 28, 2014 - 5:11 pm:    Edit Post Delete Post Print Post


Dobbey:

https://lh6.googleusercontent.com/-ovh4sb9LXh4/T1NGTBSqpQI/AAAAAAAABJA/gzrK0zHpx ig/s235/fire8.gif


MOVIEART--ali
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Mudiripoyina Bewarse
Username: Dobbey

Post Number: 19601
Registered: 12-2009
Posted From: 12.52.129.43

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

Posted on Friday, February 28, 2014 - 4:12 pm:    Edit Post Delete Post Print Post


Proofdada:


https://lh6.googleusercontent.com/-ovh4sb9LXh4/T1NGTBSqpQI/AAAAAAAABJA/gzrK0zHpx ig/s235/fire8.gif
Top of pagePrevious messageNext messageBottom of page Link to this message

Bewarsegadu
Kurra Bewarse
Username: Bewarsegadu

Post Number: 1177
Registered: 03-2013
Posted From: 65.198.163.148

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

Posted on Friday, February 28, 2014 - 3:43 pm:    Edit Post Delete Post Print Post

kummu PD baa kummu
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134123
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:38 pm:    Edit Post Delete Post Print Post


Godfather:


ell ellaavaa...MOVIEART--gutti2
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 74844
Registered: 03-2004
Posted From: 83.89.94.127

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

Posted on Friday, February 28, 2014 - 3:31 pm:    Edit Post Delete Post Print Post

MOVIEART--sunil.cry
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134122
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:29 pm:    Edit Post Delete Post Print Post


Bignole:


MOVIEART--bemmi.dance1
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134121
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:29 pm:    Edit Post Delete Post Print Post


Dobbey:



Gochi:


MOVIEART--bemmi.sarle
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Bignole
Celebrity Bewarse
Username: Bignole

Post Number: 25589
Registered: 03-2004
Posted From: 137.254.4.8

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

Posted on Friday, February 28, 2014 - 3:28 pm:    Edit Post Delete Post Print Post


Proofdada:


Job hochindanta ga kwangrats dada
CLIPART--smokeTmmirekkuvaithe Manchamekkali Kani Spot ki Raakudadhu Raa
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 82162
Registered: 07-2004
Posted From: 8.7.228.252

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

Posted on Friday, February 28, 2014 - 3:28 pm:    Edit Post Delete Post Print Post

correstey dada...Sum(CASE...) logic raayali nuvvu postinattu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Mudiripoyina Bewarse
Username: Dobbey

Post Number: 19600
Registered: 12-2009
Posted From: 12.52.129.43

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

Posted on Friday, February 28, 2014 - 3:28 pm:    Edit Post Delete Post Print Post

Select count() from table
Union
Select count() from table
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134120
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:28 pm:    Edit Post Delete Post Print Post


Ferrari:


avvindhiMOVIEART--bemmi.sarle
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134119
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:27 pm:    Edit Post Delete Post Print Post


Symbol_of_king:


late avvindhiMOVIEART--bemmi.sarle
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Ferrari
Mudiripoyina Bewarse
Username: Ferrari

Post Number: 10664
Registered: 09-2010
Posted From: 207.173.232.98

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

Posted on Friday, February 28, 2014 - 3:27 pm:    Edit Post Delete Post Print Post


Proofdada:

SUM(CASE WHEN Persons.Name = 'John' THEN 1 ELSE 0 END) AS JohnCount,
SUM(CASE WHEN Persons.Name = 'John' AND Persons.Age > 30 THEN 1 ELSE 0 END) AS OldJohnsCount,
COUNT(*) AS AllPersonsCount



idedhedho dorkindhi meeting tharuvatha ee model fallow aytha...




idi work avuddi mostly
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
Top of pagePrevious messageNext messageBottom of page Link to this message

Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king

Post Number: 2161
Registered: 12-2005
Posted From: 75.93.50.185

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

Posted on Friday, February 28, 2014 - 3:27 pm:    Edit Post Delete Post Print Post

select count(items),sum(case when closeddate is null then 0 else 1 end) from items where xxxxx
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134118
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:27 pm:    Edit Post Delete Post Print Post

itta googling sesukuni omlika la sukoon ga bathikeyochu anamaata...MOVIEART--sunil.cry
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134117
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:25 pm:    Edit Post Delete Post Print Post

SUM(CASE WHEN Persons.Name = 'John' THEN 1 ELSE 0 END) AS JohnCount,
SUM(CASE WHEN Persons.Name = 'John' AND Persons.Age > 30 THEN 1 ELSE 0 END) AS OldJohnsCount,
COUNT(*) AS AllPersonsCount



idedhedho dorkindhi meeting tharuvatha ee model fallow aytha...
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134116
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:22 pm:    Edit Post Delete Post Print Post

select stmt loopala colums selection daggara...

count(select closeddate from fs_item where closeddate is not null) idhi edthe thenkara fooka, akkada select endhi nee devasam antaandhi...MOVIEART--bemmi.abba
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134115
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:21 pm:    Edit Post Delete Post Print Post

eeti thinkuthunnara...fata fata seppeseyalamma...eeyy dwh candis...MOVIEART--bemmi.angry
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134113
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:18 pm:    Edit Post Delete Post Print Post

sql gurusMOVIEART--bemmi.lungi2
Narsiah fans Ramu,Gali...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 134110
Registered: 03-2004
Posted From: 72.54.157.179

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

Posted on Friday, February 28, 2014 - 3:13 pm:    Edit Post Delete Post Print Post

select count(items), count(closeddate is not null) from items where xxxxx(some condition with dates)

basic ga aa closed date not null count correct ga ravali kaani adhi number of closed date rows ichesthandhi, it means items count and closed dates count okate isthandhi...

neenu rasindhi thappe kaani, aa option etta rayatam oka query loone

I need all item counts, and count of closed date not null kaavali....

where clause loo aa not null option pettaleemu...ekkada ettali etta ettalooo soopinchundri ettestha...
Narsiah fans Ramu,Gali...

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