查询数据库的几个示例

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'

 

 

 

posted @ 2016-08-20 15:48  刘要直  阅读(492)  评论(0编辑  收藏  举报