sqlserver 查询结果作为查询本表的条件（子查询）select gsid from chiye_yw

只想查询id对应都结束的数据信息 3和4.怎么写sql语句
select gsid from chiye_yw where setime <GETDATE() and not exists(select gsid from chiye_yw where setime>=GETDATE())