pc520 发表于 2009-11-17 15:45

<p>**** Hidden Message *****</p><p></p>

CiCi-Hsu 发表于 2009-11-17 21:00

<p>**** Hidden Message *****</p>

zhang84997 发表于 2009-11-19 11:29

**** Hidden Message *****<table cellspacing="0" cellpadding="0" width="468" border="0" style="WIDTH: 351pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td colspan="5" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><p><font face="宋体"></font></p></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table>7组103交练习

zhh823543 发表于 2009-11-19 21:55

**** Hidden Message *****

monvzhilei 发表于 2009-11-29 21:17

<p></p><p>我来做题目了。</p><p></p><p>SELECT `数据源$`.犯规<br/>FROM `C:\Documents and Settings\Administrator\桌面\Sql习题`.`数据源$` `数据源$`<br/>WHERE (`数据源$`.球员 Like '%斯%')</p><p></p><p>SELECT `数据源$`.球员<br/>FROM `C:\Documents and Settings\Administrator\桌面\Sql习题`.`数据源$` `数据源$`<br/>WHERE (`数据源$`.助攻&gt;50) AND (`数据源$`.失误&lt;20)</p><p></p><p><br/>SELECT `数据源$`.球员<br/>FROM `C:\Documents and Settings\Administrator\桌面\Sql习题`.`数据源$` `数据源$`<br/>WHERE (`数据源$`.首发&lt;&gt;0)</p>

亡者天下 发表于 2009-11-30 13:31

**** Hidden Message *****<br/>
[此贴子已经被作者于2009-11-30 15:12:02编辑过]

菱荇 发表于 2009-12-29 20:11

学习了

EP江淮 发表于 2010-10-3 09:14

看看，不会做　　　　　

厦门行 发表于 2010-10-31 09:36

<p>select T.* from (select 到货日期 as [到/送货日期], 入库单号 as [入库单号/货单号], 合同号, 供应商名 as [供应商名/客户名], 客户料单号, 货物编码, 货物名称, 规格型号, 单位, [数量(PC)] as [入库数量(PC)], [单价(￥/PC)] as [入库单价(￥/PC)], [金额(￥)] as [入库金额(￥)], 0 as [出库数量(PC)], 0 as [出库单价(￥/PC)], 0 as [出库金额(￥)] from [入库明细$] union all<br/>select 送货日期, 货单号, 合同号, 客户名, 客户料单号, 货物编码, 货物名称, 规格型号, 单位, 0 as [入库数量(PC)], 0 as [入库单价(￥/PC)], 0 as [入库金额(￥)], [数量(PC)] as [出库数量(PC)], [单价(￥/PC)] as [出库单价(￥/PC)], [金额(￥)] as [出库金额(￥)] from [出库明细$]) T order by T.[到/送货日期] T.[入库数量(PC)] DESC</p>

happywgl 发表于 2010-10-31 13:43

aaaaaaaaaaaaa
页: 1 [2] 3 4
查看完整版本: [1期透视表班习题6]Sql基础练习(有奖)