技術文章
| SQL查詢非空記錄、SQL查詢值為空的記錄 |
| 發布時間：2009-09-18 點擊次數：12323 |
查詢非空記錄 方法一、sql="select * from table where id<>null " 方法二、sql="select * from table where len(id)>1" 方法二、select * from News where Newstype = "指定值" and newspic is not Null order by NewsID desc 查詢值為空的記錄 select * from News where Newstype = "指定值" and newspic is Null order by NewsID desc 其它的反之 |
