sql
iteye_13425
这个作者很懒,什么都没留下…
展开
-
字符串排序
select * from table1 order by strId*1 ASC原创 2013-12-29 20:26:39 · 63 阅读 · 0 评论 -
sql 匹配字段中开头统计数据
select SUM(INCREASED_TOURIST_COUNT) sumres,left(CUR_HOUR,10) day from MEAS_HOURLY_TOURISTS <dynamic prepend="WHERE"> <isNotEmpty prepend="AND" property="scenic_area_code"> scenic_area...原创 2014-09-28 17:24:18 · 525 阅读 · 0 评论