数据库
IT小白兔
这个作者很懒,什么都没留下…
展开
-
oracle sql 基本操作
select t.longitude into longitudeTemp from b_n_maplonglat t where t.sortno=i and t.maprouteid='5cd76cb9-7658-4d82-b47b-fff10148f84c';原创 2014-08-14 18:51:12 · 188 阅读 · 0 评论 -
oracle 数据库操作
1、distinct 剔除重复,count(1),查询重复的行数,group by having 相当于where select distinct deptid,siteid,updownid,devicecode,count(1) from j_device where deptid=1398 and siteid=1189 and updownid=1 and statue=0 an原创 2014-12-11 15:58:00 · 231 阅读 · 0 评论 -
oracle 的rownum
select awmid,yxjstpath,to_char(awmtime,'yyyy-mm-dd') as awmtime,awmaddress,hostempname,joinnum from (select t.awmid,t.yxjstpath,t.awmtime,t.awmaddress,t.hostempname,t.joinnum from b_r_assignworkmeeti原创 2016-04-12 15:36:42 · 228 阅读 · 0 评论