我写的7-12 排名

Question

select top 6  * from xl_article
where articleid>(select max(articleid) from xl_article where articleid in( select top 6 articleid from xl_article ))

Answer 1

也可以啊。不过用row_number估计可能快一些

Answer 2

select top 6 * from (select top 12 * from csdn.user order by points desc) order by points asc不对啊

Answer 3

select top 6  * 
from xl_article a
where not exists( select top 6 articleid from xl_article  where articleid = a.articleid  )

Answer 4

ArticleId   DefaultPicture                                                                                                                                                                                           Title                                              Leadin                                                                                               Content                                                                                                                                                                                                                                                          Editor     UpdateTime                                             栏目流水号       
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ------------------------------------------------------ ----------- 
14          ImageArticle/plglenn9.jpg                                                                                                                                                                                吃遍京城 个性餐厅大搜索                                       吃遍京城 个性餐厅大搜索吃遍京城 个性餐厅大搜索                                                                             NULL                                                                                                                                                                                                                                                             NULL       2009-12-11 16:12:39.123                                3
15          ImageArticle/plglenn9.jpg                                                                                                                                                                                寻找隆福寺当年味道                                          寻找隆福寺当年味道寻找隆福寺当年味道                                                                                   NULL                                                                                                                                                                                                                                                             NULL       2009-12-11 16:12:39.123                                2
16          ImageArticle/plglenn9.jpg                                                                                                                                                                                秦唐中餐厅 金街上的国际顶                                      秦唐中餐厅 金街上的国际顶秦唐中餐厅 金街上的国际顶                                                                           NULL                                                                                                                                                                                                                                                             NULL       2009-12-11 16:12:39.123                                3
17          ImageArticle/plglenn9.jpg                                                                                                                                                                                京城最佳法式美食地精选                                        京城最佳法式美食地精选京城最佳法式美食地精选                                                                               NULL                                                                                                                                                                                                                                                             NULL       2009-12-11 16:12:39.123                                3
18          ImageArticle/plglenn9.jpg                                                                                                                                                                                金城阁餐厅 不一样的五星级                                      金城阁餐厅 不一样的五星级金城阁餐厅 不一样的五星级                                                                           NULL                                                                                                                                                                                                                                                             NULL       2009-12-11 16:12:39.123                                3
19          ImageArticle/plglenn9.jpg      

Answer 5

select top 6 * from(
select top 12 *
from xl_article 
order by ArticleId 
) order by ArticleId desc