SQL嵌套查询出现问题

如下代码，没有问题

(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER0_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t1)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER2_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t2)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER3_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t3)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER4_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t4)

我在套个select * from为啥就报错

SELECT * FROM 
((SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER0_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t1)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER2_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t2)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER3_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t3)
UNION ALL 
(SELECT * FROM (SELECT TOP(1)
timestamp,B10Z5CARSTYLECOUNTER4_VAL0 as num
FROM dbo.CAR_NUMBER
ORDER BY timestamp DESC) AS t4))

报这个错误

Incorrect syntax near 'End Of File'.  Expecting AS, FOR_PATH, ID, or QUOTED_ID

求大佬指点

在最后的右括号“）”报错

可以试试看，在最最最后面加一个as （这里随便写个东西），我举个例子 as all_time就行了