我有一个数据库, ProjID (int 主键), Project (varchar), Notify (int)
现在我要根据 Notify 的值来查询某一条记录,比如 Notify = 10 ,我就是要查询
数据库中第10条记录,
这个用 select 语句怎么来查询 ?
DECLARE @CurrID int
SELECT @CurrID = notify FROM Project_Projects
exec('select top 1 * from (select top '+@CurrID+' * from tb) a order by projid desc')