| Author |
Message |
    
Ekambaram
Kurra Bewarse
Username: Ekambaram
Post Number: 1218
Registered: 08-2005
Posted From: 209.12.236.10
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:52 pm: |    |
-NONE- |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 45500
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:12 pm: | |
ante first sum chesi,malli sum taruvata malli diff ante query performance ki server gosi oodidhi
 nee yenks alaa lopala subquery raasina multiple records ki doola theeruddi performance...output loni every record ki subquery run avvali
so rendu test cheyyi,edi fastoo adhi pollow ayipo 
Donate Blood Save Life ! Donate Eyes Live Twice  |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 905
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:11 pm: | |
 |
420
Kurra Bewarse
Username: 420
Post Number: 2361
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:11 pm: | |
escuseeeeeeeeeee me .. what is SQL
Chirutaa ... One more clown on the way |
Pda
Celebrity Bewarse
Username: Pda
Post Number: 14253
Registered: 06-2006
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:09 pm: | |
Life is a game. So fight for survival and see if you're worth it. |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14069
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:09 pm: | |
gochi mama,
aa sachu telivi teliyaka na...
ante first sum chesi,malli sum taruvata malli diff ante query performance ki server gosi oodidhi 
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14068
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:07 pm: | |
yea sam mama cheppinattu use cheyyali inka..nenu inni rojulu...alias difference work avvutundhi anukunna...
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 45497
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:07 pm: | |
II maama,itta seseyyi 
select (sum(select sum(sal)from sample1)) X,
(sum(select sum(bonus) from sample2)) Y,
(sum(select sum(sal)from sample1)) - (sum(select sum(bonus) from sample2)) as diff
from sample .....
mottham raayaka thappadhu bayata aithe....
Donate Blood Save Life ! Donate Eyes Live Twice |
420
Kurra Bewarse
Username: 420
Post Number: 2360
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:07 pm: | |
Chirutaa ... One more clown on the way |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 904
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:05 pm: | |
select (X-Y) diff from ((sum(select sum(sal)from sample1)) X, (sum(select sum(bonus) from sample2)) Y from sample ); |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 903
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:04 pm: | |
appudu sam chepinindi use cheyyi saripothundi |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14066
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 3:00 pm: | |
pda mama...
X-Y use cheyyali ani telusu mama kani
X anedhi aggregate sum
Y anedhi inko aggregate sum
like
select (sum(select sum(sal)from sample1)) X, (sum(select sum(bonus) from sample2)) Y, (X-Y) diff from sample
idi mama query...
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 45493
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:56 pm: | |
 nee yenks II maama
Donate Blood Save Life ! Donate Eyes Live Twice |
Sam
Kurra Bewarse
Username: Sam
Post Number: 2490
Registered: 03-2004
Posted From: 65.114.90.194
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:54 pm: | |
You can do thi with derived sql:
select
q1.a,
q1.b,
q1.a-q1.b as diff
from
(select x as a, y as b from Table t1) as q1 |
Pda
Celebrity Bewarse
Username: Pda
Post Number: 14250
Registered: 06-2006
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:52 pm: | |
b invald ane enduku vattadi ante query last nunchi first ki parse chestundi SQL engine.. so first B vachindi kabatti.. b invalid..
select X as a, Y as b,(b/a) as diff from sample
lo a invalid ani vastundi
Life is a game. So fight for survival and see if you're worth it. |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 902
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:52 pm: | |
alias will work only after "from " clause |
Pda
Celebrity Bewarse
Username: Pda
Post Number: 14249
Registered: 06-2006
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:50 pm: | |
X-Y ani rayali a-b work avvadu
Life is a game. So fight for survival and see if you're worth it. |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14060
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, August 23, 2007 - 2:48 pm: | |
select X as a, Y as b,(a - b) as diff from sample
ani iste b is invalid identifier ani vastundhi....
endukani?
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
