从csdn论坛学sql--1

sql语句

写法一：

select id, name from
( select 1 as id, 'new' as name 
  UNION  select 2 as id, 'dealing' as name 

  UNION  select 3 as id, 'shipped' as name

) t--加个别名，子查询结果作为表要加别名

解释：

select * from
(
     selelct *****************************************
) as T
子查询相对最外层的select ，少个表名.把括号里的子查询起个别名。

 

写法二：

select [id], [name] from
(select 1 as [id], 'new' as [name] 
UNION 
select 2 as [id], 'dealing' as [name] 
UNION 
select 3 as [id], 'shipped' as [name]) as t

解释：

SQL语言提供一些保留关键字，属于数据库自身要用的。在建立表时，如果表名以及数据字段名用到关键字，那么在以后调用时就需要加上[]括起来。