Missing Operator, SQL

Question

I can't seem to find where I'm missing an operator. I've looked at this many times, I tried signle quotes, double quotes, checked field names, I'm outta options.

Here is how "SQL1" is being created, this runs fine.

SELECT ID, Result, (SELECT COUNT(*) FROM Table1 G WHERE G.Result <> GR.Result AND G.ID <= GR.ID) AS RunGroup FROM Table1 AS GR;

Here is how "SQL2" is being created, this also runs fine.

SELECT Result, MIN(ID) AS StartID, MAX(ID) AS EndID, COUNT(*) AS Games FROM SQL1 AS A GROUP BY Result, RunGroup ORDER BY Min(ID);

When it comes to this query, is says syntax error, missing operator, then highlights "Result".

SELECT TOP 1 * FROM SQL2 A ORDER BY Games, WHERE Result = "W";

Suggestions?

WHERE Result = "W" ORDER BY Games; in other words take out the comma and switch the 'where' and 'order by clauses' — Hugh Jones
– Hugh Jones, Commented Aug 4, 2014 at 15:49

yassine__ · Accepted Answer · 2014-08-04 15:48:33Z

1

try this :

SELECT TOP 1 * FROM SQL2 A WHERE Result = 'W' ORDER BY Games;

answered Aug 4, 2014 at 15:48

yassine__

3934 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Missing Operator, SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related