查詢資料庫的幾個示例

select * from ZWGL_LiShiZhuangTaiJiLu where RFID='584115554845' order by JianCeShiJian desc;

select * from ZWGL_LiShiZhuangTaiJiLu where ZaiWeiZhuangTai=1  order by JianCeShiJian desc;


select * from ZWGL_ZhuangTaiJiLu zt where (ZaiWeiZhuangTai != 1)


select ZhuangBeiName from BQ_ZhuCe where RFID='584115554845'