sql语句
揽峰moc
这个作者很懒,什么都没留下…
展开
-
平时工作几条sql语句记录
[code="java"]。。。统计某水电厂某年每个月累计供水量select Month(t2.tm) as time,SUM(t2.ll) as tll,t1.stnm as names from LL_ZD_DATA t1 inner join LL_SS_DATA t2 on t2.stcd=t1.stcd where t2.stcd='00000002'...原创 2014-01-14 11:25:27 · 105 阅读 · 0 评论 -
oracle中单字段存在1个或2个关联id时的查询sql
[code="java"]//上午值班人数为1人或2人时,查出值班信息和个人信息select b.contact as mContact,b.email as mEmail,c.contact as m2Contact,c.email as m2Email,t.* from(selectsubstr(a.morning_people_ids,0,instr(a.mornin...原创 2015-09-06 15:10:22 · 179 阅读 · 0 评论 -
字段按照汉语拼音首字母A-Z排序
[b]一、汉字首字母拼音A-Z排序[/b]方法一:MySQL数据库下[url]https://blog.csdn.net/wjy_treasure/article/details/73119630[/url][code="java"]select * from t_student order by CONVERT(trim(user_name) USING gbk) asc;[...原创 2018-07-27 15:34:33 · 1974 阅读 · 0 评论