select top 12 * from (select F_ClassID,F_Field1,F_AddTime,F_ID,F_HTMFile,(select Class_name from T_Class where Class_ID=a.F_ClassID) as ClassName ,F_isRed,F_isBold,F_isTop from T_Resource a where F_Status = 1 and SecondCHID in (1) and F_ClassID in (409,410,413,414,415,416,712,411,421,426,718,719,723,724,725,726,727,728,729,730,731,720,721,722,732,733,734) and F_ID<>279999 and () ) b order by F_isTop DESC , F_Field1 desc 获取数据错误!select top 12 * from (select F_ClassID,F_Field1,F_AddTime,F_ID,F_HTMFile,(select Class_name from T_Class where Class_ID=a.F_ClassID) as ClassName ,F_isRed,F_isBold,F_isTop from T_Resource a where F_Status = 1 and SecondCHID in (1) and F_ClassID in (409,410,413,414,415,416,712,411,421,426,718,719,723,724,725,726,727,728,729,730,731,720,721,722,732,733,734) and F_ID<>279999 and () ) b order by F_isTop DESC , F_Field1 desc | |