34,873
社区成员
发帖
与我相关
我的任务
分享sql语句
select rybh,rymc,csrq as sr from rydm where sr is not null
显示sr是无效的列名。我怎么能用别名作搜索条件呢？
显示sr是无效的列名。我怎么能用别名作搜索条件呢？
...全文
请发表友善的回复…
发表回复
futulove 2004-07-17
- 打赏
- 举报
哦，没看到三楼以经回答过了，Sorry
futulove 2004-07-17
- 打赏
- 举报
可以这样的
select * from (select rybh,rymc,csrq as sr from rydm) a where a.sr is not null
select * from (select rybh,rymc,csrq as sr from rydm) a where a.sr is not null
chentony 2004-07-17
- 打赏
- 举报
對不能用別名作條件判斷哦
hudan 2004-07-16
- 打赏
- 举报
select * from (select rybh,rymc,csrq as sr from rydm) b where b.sr is not null
gaohenglove 2004-07-16
- 打赏
- 举报
select rybh,rymc,(......表达式....) as sr from rydm where ...
难道我要用如此长的表达式作搜索？
难道我要用如此长的表达式作搜索？
cgsun 2004-07-16
- 打赏
- 举报
select rybh,rymc,csrq as sr from rydm where csrq is not null
