List:General Discussion« Previous MessageNext Message »
From:Kelly W [PCS] Black Date:October 31 2002 6:01pm
Subject:sql query
View as plain text  
Pretty lame.

-----Original Message-----
From: mysql@stripped [mailto:mysql@stripped]
Sent: Thursday, October 31, 2002 11:58 AM
To: Black, Kelly W [PCS]
Subject: Re: SELECT 


Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

sql,query

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:

Hi

I could use some advice on a select statement.

I have this select statement, which works great:

SELECT sum(att) as att , sum(lc) as lc , sum(csh) as csh, 
ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2)

AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as
suf, 
ROUND((SUM( tccf + bpp + bpc + suf) *100 ),2) / ROUND(SUM(att),2)
AS blocks, sum(mou) as mou, release FROM ss WHERE release=CURDATE()
AND (( cell=2 and sector=1) OR (cell=3 and sector=1))
GROUP BY cell ORDER BY hour;

However I want to be able to sum the two rows displayed together as
well.....
Right now it produces this =>
+------+------+------+-------+------+------+------+------+---------+------+-
-----------+
| att  | lc   | csh  | drops | tccf | bpp  | bpc  | suf  | blocks  | mou  |
release    |
------+------+------+------+-------+------+------+------+------+---------+--
----+------------+
|   75 |    4 |    2 |  9.23 |   10 |    0 |    0 |    0 | 13.3333 |  232 |
2002-10-31 |
|  644 |   24 |    8 |  5.03 |    8 |    0 |    0 |    0 |  1.2422 | 1802 |
2002-10-31 |
+------+------+------+------+-------+------+------+------+------+---------+-
-----+------------+


I want it to produce something like this _>

+------+------+------+-------+------+------+------+------+---------+------+-
-----------+
| att  | lc   | csh  | drops | tccf | bpp  | bpc  | suf  | blocks  | mou  |
release    |
+------+------+------+-------+------+------+------+------+---------+------+-
-----------+
|   739 |   28 |   10 | 11.3 |  18 |    0 |    0 |    0 | 14.5333 |  2032 |
2002-10-31 |
+------+------+------+-------+------+------+------+------+---------+------+-
-----------+

And help or ideas would be most appreciated....


Regards,

Kelly Black

Irvine, Ca. 92612

Linux was very clearly the answer, but what was the question again?

Thread
sql queryKelly W [PCS] Black31 Oct
  • Re: sql queryMichael T. Babcock31 Oct
RE: sql queryKelly W [PCS] Black1 Nov