求个SQL语句

表数据如下：
ID          NUM
---------------------
1          10
2          -50   
3          -100
4          30
5          50
6          60
7          -200
8          70
9          200
10          80
……

字段NUM的数据，有正有负，记录是会增加的。
我想取出最后一次出现  NUM为负数的ID
不知SQL该如何写?

---

SQL code:
select top id from tb where num<0 order by id desc

---

select top 1 id from tb
where num <0
order by id

---

select top 1 id from tb
where num <0
order by id desc


楼上的好快啊

---

SQL code:
select top 1 id
from tb
where num<0
order by id desc

---

引用

SQL codeselecttop idfrom tbwhere num<0orderby iddesc

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freew