随笔分类 -  db

几个sql语句
摘要：select extract(YEAR FROM t.dateordered) AS 年度,extract(MONTH FROM t.dateordered) as 月份,p.name as 供应商名字,sum(t.linenetamt) 合计from c_orderline2 tleft join c_bpartner p on p.c_bpartner_id=t.c_bpartner_idgroup by extract(YEAR FROM t.dateordered),extract(MONTH FROM t.dateordered),p.namehaving extract(YEAR 阅读全文
posted @ 2011-01-25 13:35 hayley 阅读(173) 评论(0) 推荐(0)