我的数据库有字段paperId,year
paperId的纪录为A1,A2,A3,A4,B1,B2,B3,B4,C4,C3,C2,C1是varchar类型的
year纪录为年份2007也是varchar型的怎么用查询语句按照paperId与yeah用desc查询出来
纪录出来是
paperId year
A4 2007
A3 2007
A2 2007
A1 2007
B4 2007
B3 2007
B2 2007
B1 2007
C4 2007
C3 2007
C2 2007
C1 2007
paperId的纪录为A1,A2,A3,A4,B1,B2,B3,B4,C4,C3,C2,C1是varchar类型的
year纪录为年份2007也是varchar型的怎么用查询语句按照paperId与yeah用desc查询出来
纪录出来是
paperId year
A4 2007
A3 2007
A2 2007
A1 2007
B4 2007
B3 2007
B2 2007
B1 2007
C4 2007
C3 2007
C2 2007
C1 2007
from Peter (www.kingofcoder.com编程王站站长)
from Table1 A
inner join Table B on 1=1
ORDER BY B.year DESC, A.paperId DESC
UNION ALL
SELECT 'A2' AS paperId
UNION ALL
SELECT 'A3' AS paperId
UNION ALL
SELECT 'A4' AS paperId
UNION ALL
SELECT 'B1' AS paperId
UNION ALL
SELECT 'B2' AS paperId
UNION ALL
SELECT 'B3' AS paperId
UNION ALL
SELECT 'B4' AS paperId
UNION ALL
SELECT 'C1' AS paperId
UNION ALL
SELECT 'C2' AS paperId
UNION ALL
SELECT 'C3' AS paperId
UNION ALL
SELECT 'C4' AS paperId SELECT *
FROM #T1 a
INNER JOIN #T2 b ON 1=1
ORDER BY b.Year DESC, LEFT(a.paperId, 1) ASC, RIGHT(a.paperId, 1) DESCDROP TABLE #T1
DROP TABLE #T2