
SQL
文章平均质量分 81
andli0726
这个作者很懒,什么都没留下…
展开
-
SQL语句
/*抄牌管理:CS_QW_TIEDANSB*/select * from CS_QW_TIEDANSB where personguid ='1c7454cc-d6d0-4122-9b3f-d4cb993ebe9d' order by uptime desc/*拖车业务:CS_QW_TUOCHESB*/select * from CS_QW_TUOCH...原创 2012-03-20 11:07:08 · 114 阅读 · 0 评论 -
Oracle——按时间段查询
按照多个时间段查询:包括秒String sql = "from Sedimentpermit"; sql += " where Carno like '%" + carno + "%'"; sql += " and road like '%" + road + "%'"; sql += " and to_char(VALIDDATE,'yyyy-mm-dd') &a原创 2012-07-31 15:34:47 · 406 阅读 · 0 评论