sql语句

[鹿梓]

SELECT TOP 8 * FROM EPRecruitment WHERE id NOT IN( SELECT TOP 0 id FROM EPRecruitment ORDER BY ZpTime desc ) ORDER BY ZpTime desc 

我要在这句sql中再添加一个条件 where PostName='策划总监' 添加在哪里？

[阿非]

id NOT IN( SELECT TOP 0 id FROM EPRecruitment ORDER BY ZpTime desc )

有用到么？

[阿非]

SELECT TOP 8 * FROM EPRecruitment WHERE  PostName='策划总监'  ORDER BY ZpTime desc 

[鹿梓]

[Quote=引用 2 楼 sandy945 的回复:]
SQL code

SELECT TOP 8 * FROM EPRecruitment WHERE PostName='策划总监' ORDER BY ZpTime desc
[/Quote]

但是我要分页啊...

[阿非]

那就两个位置都要加

[dalmeeme]

SELECT TOP 8 * FROM EPRecruitment WHERE id NOT IN( SELECT TOP 0 id FROM EPRecruitment where PostName='策划总监' ORDER BY ZpTime desc ) and PostName='策划总监' ORDER BY ZpTime desc