| Author |
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: |
|
Dobbey:https://lh6.googleusercontent.com/-ovh4sb9LXh4/T1NGTBSqpQI/AAAAAAAABJA/gzrK0zHpx ig/s235/fire8.gif
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
|
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: |
|
Proofdada:
https://lh6.googleusercontent.com/-ovh4sb9LXh4/T1NGTBSqpQI/AAAAAAAABJA/gzrK0zHpx ig/s235/fire8.gif
•••••
|
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: |
|
kummu PD baa kummu |
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: |
|
Godfather:
ell ellaavaa...
Narsiah fans Ramu,Gali...
|
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: |
|
 |
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: |
|
Bignole:
Narsiah fans Ramu,Gali...
|
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: |
|
Dobbey:
Gochi:
Narsiah fans Ramu,Gali...
|
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: |
|
Proofdada:
Job hochindanta ga kwangrats dada
 Tmmirekkuvaithe Manchamekkali Kani Spot ki Raakudadhu Raa
|
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: |
|
correstey dada...Sum(CASE...) logic raayali nuvvu postinattu.. |
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: |
|
Select count() from table
Union
Select count() from table
•••••
|
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: |
|
Ferrari:
avvindhi
Narsiah fans Ramu,Gali...
|
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: |
|
Symbol_of_king:
late avvindhi
Narsiah fans Ramu,Gali...
|
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: |
|
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
|
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: |
|
select count(items),sum(case when closeddate is null then 0 else 1 end) from items where xxxxx |
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: |
|
itta googling sesukuni omlika la sukoon ga bathikeyochu anamaata...
Narsiah fans Ramu,Gali...
|
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: |
|
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...
|
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: |
|
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...
Narsiah fans Ramu,Gali...
|
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: |
|
eeti thinkuthunnara...fata fata seppeseyalamma...eeyy dwh candis...
Narsiah fans Ramu,Gali...
|
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: |
|
sql gurus
Narsiah fans Ramu,Gali...
|
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: |
|
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...
|
Archives - 2014