如果希望在别名中使用空格,并要保留空格,就必须使用双引号将别名正文引起来。
在别名之前,也可以使用可选的关键字AS
select price as price from emp:
select price as "price" from emp:
select price "price on emp " from emp;
select price as "price on emp" frmo emp;
如果希望在别名中使用空格,并要保留空格,就必须使用双引号将别名正文引起来。
在别名之前,也可以使用可选的关键字AS
select price as price from emp:
select price as "price" from emp:
select price "price on emp " from emp;
select price as "price on emp" frmo emp;
联系客服