On Mon, 19 May 2014 21:58:58 -0500
Wendy wrote:
> I'm still not getting the results I need for this query: anyone with
> any idea, help greatly appreciated.
>
> "SELECT AwayTeam As 'Team', CASE WHEN (AwayTeamScore > HomeTeamScore)
> THEN 3 WHEN (AwayTeamScore=HomeTeamScore) THEN 1 ELSE 0 END AS
Hi,
I'm still not getting the results I need for this query: anyone with any
idea, help greatly appreciated.
"SELECT AwayTeam As 'Team', CASE WHEN (AwayTeamScore > HomeTeamScore) THEN
3 WHEN (AwayTeamScore=HomeTeamScore) THEN 1 ELSE 0 END AS 'Points' FROM
Results UNION ALL SELECT HomeTeam As 'Tea
Op 15 mei 2014, om 12:09 heeft E.Pasma het volgende geschreven:
Op 14 mei 2014, om 21:44 heeft Wendy het volgende geschreven:
Hi,
Wondering if anyone can help me with the following:
-
Does anyone know how I can get the SUM() aggregate function within
this
SQLite statement?
SELECT Aw
Op 14 mei 2014, om 21:44 heeft Wendy het volgende geschreven:
Hi,
Wondering if anyone can help me with the following:
-
Does anyone know how I can get the SUM() aggregate function within
this
SQLite statement?
SELECT AwayTeam As 'Team', CASE WHEN AwayTeamScore > HomeTeamScore
TH
Hi,
Wondering if anyone can help me with the following:
-
Does anyone know how I can get the SUM() aggregate function within this
SQLite statement?
SELECT AwayTeam As 'Team', CASE WHEN AwayTeamScore > HomeTeamScore THEN
3 WHEN AwayTeamScore=HomeTeamScore THEN 1 ELSE 0 END AS 'Po
5 matches
Mail list logo