# order子句中能不能用right函数？

aikill 2004-11-08 04:45:36

...全文
157 24 打赏 收藏 举报

24 条回复

fj_jiangqi 2004-11-09
• 打赏
• 举报

-----------------------------

aikill 2004-11-09
• 打赏
• 举报

fj_jiangqi 2004-11-09
• 打赏
• 举报

-----------------------------

aikill 2004-11-09
• 打赏
• 举报

fj_jiangqi 2004-11-09
• 打赏
• 举报

-----------------------------

aikill 2004-11-09
• 打赏
• 举报

boomit 2004-11-09
• 打赏
• 举报

aikill 2004-11-09
• 打赏
• 举报

select *,right(aa,4) as orderfield from t1 order by orderfield

xclzteb 2004-11-09
• 打赏
• 举报

LAIYANGPJ 2004-11-09
• 打赏
• 举报

TO:楼主

aikill 2004-11-09
• 打赏
• 举报

LAIYANGPJ 2004-11-09
• 打赏
• 举报

SELECT DISTINCT A.* FROM BB A,(SELECT RIGHT(AA,4) AS AAK,* FROM BB) B WHERE A.AA=B.AA ORDER BY A.AAK
fj_jiangqi 2004-11-09
• 打赏
• 举报

-----------------------------

aikill 2004-11-09
• 打赏
• 举报

fj_jiangqi 2004-11-09
• 打赏
• 举报

-----------------------------

aikill 2004-11-09
• 打赏
• 举报

fj_jiangqi 2004-11-08
• 打赏
• 举报

select aa,substr(' '||aa,length(aa)-4) as aar4 from t1 order by aar4

select aa,substr(' '||aa,length(' '||aa)-4) as aar4 from t1 order by aar4
-----------------------------

fj_jiangqi 2004-11-08
• 打赏
• 举报

select aa,substr(aa,length(aa)-4) as aar4 from t1 order by aar4

select aa,substr(' '||aa,length(aa)-4) as aar4 from t1 order by aar4
-----------------------------

fj_jiangqi 2004-11-08
• 打赏
• 举报

-----------------------------

LAIYANGPJ 2004-11-08
• 打赏
• 举报

2573

VFP，是Microsoft公司推出的数据库开发软件，用它来开发数据库，既简单又方便。

2004-11-08 04:45