Franciswmf的专栏 http://franciswmf.iteye.com/

java project, web project, web service project, flex project,......

字段按照汉语拼音首字母A-Z排序

[b]一、汉字首字母拼音A-Z排序[/b] 方法一:MySQL数据库下 [url]https://blog.csdn.net/wjy_treasure/article/details/73119630[/url] [code="java"] select...

2018-07-27 15:34:33

阅读数 353

评论数 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 m2Em...

2015-09-06 15:10:22

阅读数 51

评论数 0

平时工作几条sql语句记录

[code="java"] 。。。统计某水电厂某年每个月累计供水量 select Month(t2.tm) as time, SUM(t2.ll) as tll, t1.stnm as names from LL_ZD_DATA t1 inn...

2014-01-14 11:25:27

阅读数 15

评论数 0

提示
确定要删除当前文章?
取消 删除