![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 113 阅读 · 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( select substr(a.morning_people_ids,0,instr(a.mornin...原创 2015-09-06 15:10:22 · 194 阅读 · 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 · 2019 阅读 · 0 评论