摘要:
SELECT COUNT(1),CASE WHEN LEFT(USE_WORKNO,2)>80 THEN '19'+LEFT(USE_WORKNO,2) ELSE '20'+LEFT(USE_WORKNO,2) END AS A FROM TBLSYSUSER WHERE USE_WORKNO '' GROUP BY LEFT(USE_WORKNO,2) ORDER BY A这条SQL语句在... 阅读全文
posted @ 2005-08-24 18:47 Arping.Net探索 阅读(1355) 评论(0) 推荐(0) 编辑