select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) order by ID descorder by ID asc肯定不需要
select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) order by ID descorder by ID asc肯定不需要
select top 5 title,timeissue,id into a# from class1 where classid like '16%' order by ID asc, select title,timeissue from a# order by ID desc
子查询要用别名 select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc
ado.net子查询好象不能排序这样子试一下select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) as table1 order by ID desc
子查询要用别名 select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc
select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) A order by ID desc这样应该好了
而且后面的排序字段必须出现在select 后 select title,timeissue,ID from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc
select title,timeissue from a# order by ID desc
select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc
select title,timeissue from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc
select title,timeissue,ID from (select top 5 title,timeissue from class1 where classid like '16%' order by ID asc) 别名 order by ID desc