求一排序

[axiu70]

我要的是最新的10条数据里面 按TOTOP 来排序，这个要怎么写

这里ID 是唯一值， totop 是0 或是1

就是要让最新的20条里面totop 是1 的排前面。

这个要怎么写

SELECT TOP 10 * from table ORDER BY totop DESC 这写法不可以的。

SELECT TOP 20 * from table ORDER BY totop DESC,ID DESC这个写法也是不可以的。

[rucypli]

select * from (
select top 10 *
from tb
order by id desc
)T
order by totop

[王向飞]

外面再嵌套一层


order by totop desc

[youngzi]

SELECT TOP 20 * from table where totop='1' ORDER BY ID DESC

[ohfox]

ID代表新旧么?

[billpu]

是这个意思吗 从20里面再选10?
select top 10 * from tb where infoid in (select top 20 * from table order by infoid desc) order by totop desc,infoid desc

[WaterGG]

select * from 
(
  图片里的语句
)t
order by  totop DESC ,ID DESC

[youngzi]

SELECT TOP 10 * from table where totop='1' ORDER BY ID DESC

[jamk]

[Quote=引用 1 楼 rucypli 的回复:]
select * from (
select top 10 *
from tb
order by id desc
)T
order by totop
[/Quote]
嗯，外面在嵌套一层