急求一条SQL语句！

[xiaowangzi]

我现在想显示一条字段NEWSIMAGE不为空的记录！
select top 1 * from table order by newsimage desc前几天对，现在不对！为什么？

[prjM]

select top 1 * from table Where newsimage is not null

[leimin]

select top 1 * from AUTHORS Where newsimage is not null ORDER BY NEWSIMAGE DESC

[zbc]

同意楼上两位