想写一个select语句,让三个字段名字不同,但内容是一样的,
比如select a as b,c,d from 表
可以这样写 select a as b,a as c, a as d from 表但由于a 的位置也是一个查询语句,所以不想这样写,有没有别的办法啊
比如select a as b,c,d from 表
可以这样写 select a as b,a as c, a as d from 表但由于a 的位置也是一个查询语句,所以不想这样写,有没有别的办法啊
from (select col as a from ta) a子查询
select A1 as A,A1 as B, A1 as C
from (select col as A1 from ta) a
经select语句查询要返回一个表如table1
但再返回之前要对查询生成的表table1处理一下,如有列a,b,c,d,e,....当e满足为某值时就要列b=列a,返回处理完这个表
我想对于c如上述的操作再返回
select 字段1 as a,'1' as b from 表1
吗