TOP和ORDER BY的问题,急!!!
Select e.REPORTDATE,e.SYMBOL, e.FNAME, e.SNAME, e.STYPE, e.F0010, e.F0020, e.F0040, e.F0050, e.F0070, e.F0080, e.F0100, e.F0110, e.F0120, e.F0130, e.F0140,e.F0200
From (SELECT TOP 10 A.REPORTDATE,A.SYMBOL, A.FNAME, A.SNAME, A.STYPE, A.F0010, A.F0020, A.F0040, A.F0050, A.F0070, A.F0080, A.F0100, A.F0110, A.F0120, A.F0130, A.F0140,B.F0020 AS F0200
FROM TB_2005 A,TB_2038 B WHERE A.SYMBOL='260109'AND A.F0010=B.SYMBOL AND A.REPORTDATE=(SELECT MAX(REPORTDATE)AS MAXDATE FROM TB_2005 c Where a.SYMBOL=c.SYMBOL )
) as e
order by e.F0200 desc
上面的语句可以完成我想的排序 ,但是如果换成
order by e.F0110 desc 结果就不一样了 就不是按照e 表来排序的了 ,请哪位大虾赐教!