下面二个我测试时候都是错误的, 怎样写可以让他通过呢?1, select * from (select substring(convert(varchar(8),getdate(),112),3,2)) tm
2, select * from
(select max(cd) from aaa where left(cd,2)=substring(convert(varchar(8),getdate(),112),3,2)) tt
2, select * from
(select max(cd) from aaa where left(cd,2)=substring(convert(varchar(8),getdate(),112),3,2)) tt
select * from (select substring(convert(varchar(8),getdate(),112),3,2) as rq) a --2.
select * from
(select max(cd) as cd from aaa where left(cd,2)=substring(convert(varchar(8),getdate(),112),3,2)) tt
子查询中,注意要指定别名。
2, select max(cd) from aaa where left(cd,2) = substring(convert(varchar(8),getdate(),112),3,2)