sql:除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。

Question

在内联中是不是不能用ORDER BY

Answer 1

SELECT top 28 person_info.person_info_user_id,person_info.person_info_xingming,person_info.person_info_age,person_info.person_info_sex_example,person_jiaoyu.person_jiaoyu_xueli_example,person_jiaoyu.person_jiaoyu_zhuanye_name,person_gengxin.person_gengxin_indete FROM person_info,person_jiaoyu,person_gengxin ORDER BY person_gengxin.person_gengxin_id DESC

Answer 2

Select * From (SELECT person_info.person_info_user_id,person_info.person_info_xingming,person_info.person_info_age,person_info.person_info_sex_example,person_jiaoyu.person_jiaoyu_xueli_example,person_jiaoyu.person_jiaoyu_zhuanye_name,person_gengxin.person_gengxin_indete FROM person_info,person_jiaoyu,person_gengxin) as tmpTable ORDER BY person_gengxin.person_gengxin_id DESC

Answer 3

写错误点，呵呵
ORDER BY person_gengxin_id DESC

Answer 4

SELECT person_info.person_info_user_id,
       person_info.person_info_xingming,
       person_info.person_info_age,
       person_info.person_info_sex_example,
       person_jiaoyu.person_jiaoyu_xueli_example,
       person_jiaoyu.person_jiaoyu_zhuanye_name,
       COUNT(person_gengxin.person_gengxin_id),
       person_gengxin.person_gengxin_date FROM person_info,person_jiaoyu,person_gengxin WHERE person_gengxin.person_gengxin_user_id=person_info.person_info_user_id 
      AND 
      person_gengxin.person_gengxin_user_id=person_jiaoyu.person_jiaoyu_user_id GROUP BY person_info.person_info_user_id,
         person_info.person_info_xingming,
         person_info.person_info_age,
         person_info.person_info_sex_example,
         person_jiaoyu.person_jiaoyu_xueli_example,
         person_jiaoyu.person_jiaoyu_zhuanye_name,
         person_gengxin.person_gengxin_id,
         person_gengxin.person_gengxin_date 
 
HAVING COUNT(person_gengxin.person_gengxin_id)=28 ORDER BY person_gengxin.person_gengxin_id DESC我这么写一个都没查出来

Answer 5

SELECT top 28 person_info.person_info_user_id,person_info.person_info_xingming,person_info.person_info_age,person_info.person_info_sex_example,person_jiaoyu.person_jiaoyu_xueli_example,person_jiaoyu.person_jiaoyu_zhuanye_name,person_gengxin.person_gengxin_date FROM person_info,person_jiaoyu,person_gengxin WHERE person_gengxin.person_gengxin_user_id=person_info.person_info_user_id AND person_gengxin.person_gengxin_user_id=person_jiaoyu.person_jiaoyu_user_id  ORDER BY person_gengxin.person_gengxin_id DESC",connectionhaole

Answer 6

SELECT top 28是什么意思？是不是搜出28个数据，