SELECT multiple question

fitzbean · #1 (**permalink**) 01-07-05, 14:28

Hi folks, thanks for giving this a look -

I know the following query doesn't work, but it demonstrates what I'm trying to accomplish - query both total points and points for say the month of january in the same query - is this posible? If so, how?

This is what i would basically like to do more or less -
SELECT points as total_points, (points as monthly_points WHERE MONTH(ts) = 1) FROM TABLE players

Any help appreciated!
Thanks
Brad

r937 · #2 (**permalink**) 01-07-05, 22:23

Code:

select points               as total_points
     , case when month(ts)=1 
            then points 
            else null end   as monthly_points 
  from players

is there perhaps a SUM to be done here?

Internet Services

Web Development

Digital Marketing

Consumer Tech