SQL syntax error after FROM (other_query)

Question

So I'm trying to run this query on my sql server database:

SELECT MAX(timestamp)
FROM (SELECT TOP (20) timestamp
    FROM CPPM_03ChannelCountErrors 
    WHERE '2015-03-10 00:00:00' < timestamp AND timestamp < '2015-03-15 00:00:00' AND skuid = '3252' 
    ORDER BY timestamp)

And I get this error message: "Msg 102, Level 15, State 1, Line 5 Incorrect syntax near ')'."

I have already confirmed that this query by itself works just fine:

SELECT TOP (20) timestamp
FROM CPPM_03ChannelCountErrors
WHERE '2015-03-10 00:00:00' < timestamp AND timestamp < '2015-03-15 00:00:00'
AND skuid = '3252'
ORDER BY timestamp

I'm grateful if someone figures this out. It's driving me insane

juergen d · Accepted Answer · 2015-08-14 13:13:39Z

1

SELECT MAX(timestamp)
FROM 
(
    SELECT TOP (20) timestamp
    FROM CPPM_03ChannelCountErrors 
    WHERE '2015-03-10 00:00:00' < timestamp 
    AND timestamp < '2015-03-15 00:00:00' 
    AND skuid = '3252' 
    ORDER BY timestamp
) tmp

Every subquery needs an alias name. I added it and named it tmp

answered Aug 14, 2015 at 13:13

juergen d

205k40 gold badges304 silver badges377 bronze badges

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

Comments

M.Ali · Accepted Answer · 2015-08-14 13:13:55Z

0

SELECT MAX(timestamp)
FROM (SELECT TOP (20) timestamp
    FROM CPPM_03ChannelCountErrors 
    WHERE '2015-03-10 00:00:00' < timestamp 
      AND timestamp < '2015-03-15 00:00:00' AND skuid = '3252' 
    ORDER BY timestamp) t --<-- you need to alias the sub-query here

answered Aug 14, 2015 at 13:13

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

1 Comment

benjamin moskovits Over a year ago

Why are you using a subquery with a top 20? It looks like you can just use a select max with a single select. Anyway both Juergen and Ali are correct if you want to do it with a sub-query.

Collectives™ on Stack Overflow

SQL syntax error after FROM (other_query)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related