sql查询设计 请教,如何用sql语句设计成这样的表格来,或者有没有其他的方法可以实现。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title><style type="text/css"> tr,td{ text-align:center;} table{ border-collapse:collapse;} td{ font-size:14px;}</style></head><body><table border="1"> <tr> <th height="38" colspan="12">二0一二年叉车销售流向表</th> </tr> <tr> <td width="27" rowspan="2" >序号</td> <td width="112" height="26">业务员</td> <td width="100" colspan="2">张三</td> <td width="100" colspan="2">李四 </td> <td width="100" colspan="2">王五</td> <td width="100" colspan="2">赵六 </td> <td width="100" colspan="2">里斯</td> </tr> <tr> <td>国家及地区</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> </tr> <tr> <td>1</td> <td>美国</td> <td width="52"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿根廷</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿富汗</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>伊拉克</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr></table></body></html图片不行,这就是图片,忘高手们,看看 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title><style type="text/css"> tr,td{ text-align:center;} table{ border-collapse:collapse;} td{ font-size:14px;}</style></head><body><table border="1"> <tr> <th height="38" colspan="12">二0一二年叉车销售流向表</th> </tr> <tr> <td width="27" rowspan="2" >序号</td> <td width="112" height="26">业务员</td> <td width="100" colspan="2">张三</td> <td width="100" colspan="2">李四 </td> <td width="100" colspan="2">王五</td> <td width="100" colspan="2">赵六 </td> <td width="100" colspan="2">里斯</td> </tr> <tr> <td>国家及地区</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> </tr> <tr> <td>1</td> <td>美国</td> <td width="52"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿根廷</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿富汗</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>伊拉克</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr></table></body></html图片不行,这就是图片,忘高手们,看看 <table border="1"> <tr> <th height="38" colspan="12">二0一二年叉车销售流向表</th> </tr> <tr> <td width="27" rowspan="2" >序号</td> <td width="112" height="26">业务员</td> <td width="100" colspan="2">张三</td> <td width="100" colspan="2">李四 </td> <td width="100" colspan="2">王五</td> <td width="100" colspan="2">赵六 </td> <td width="100" colspan="2">里斯</td> </tr> <tr> <td>国家及地区</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> <td width="50">订单</td> <td width="50">发货</td> </tr> <tr> <td>1</td> <td>美国</td> <td width="52"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿根廷</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>阿富汗</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>伊拉克</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr></table></body></html 求SQL语句 sql 日期转换问题~ 达们求一条sql ,要查出不为空的字段 存储过程中, 用字符串变量替代表名后, 有可以替换成表名的宏或者函数吗? 怎样做被更新行的触发器 求一语句? SQl 抽出四个字段 排序问题 ??? 类型为smallmoney,显示为6.5000,怎样使其显示为6.50 ?我以前系统是简体字windows98,我要在一台电脑上安装两个系统,一个是简体,一个是繁体。如何做?**********1急急争急********8888888 Dll高手请留步:小女子吐血求救:各位高手,快救救小妹!有關Dll問題 sql注册 text类型中信息的替换问题
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
tr,td{ text-align:center;}
table{ border-collapse:collapse;}
td{ font-size:14px;}
</style>
</head><body>
<table border="1">
<tr>
<th height="38" colspan="12">二0一二年叉车销售流向表</th>
</tr>
<tr>
<td width="27" rowspan="2" >序号</td>
<td width="112" height="26">业务员</td>
<td width="100" colspan="2">张三</td>
<td width="100" colspan="2">李四 </td>
<td width="100" colspan="2">王五</td>
<td width="100" colspan="2">赵六 </td>
<td width="100" colspan="2">里斯</td>
</tr>
<tr>
<td>国家及地区</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td> </tr>
<tr>
<td>1</td>
<td>美国</td>
<td width="52"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿根廷</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿富汗</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>伊拉克</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></body>
</html图片不行,这就是图片,忘高手们,看看
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
tr,td{ text-align:center;}
table{ border-collapse:collapse;}
td{ font-size:14px;}
</style>
</head><body>
<table border="1">
<tr>
<th height="38" colspan="12">二0一二年叉车销售流向表</th>
</tr>
<tr>
<td width="27" rowspan="2" >序号</td>
<td width="112" height="26">业务员</td>
<td width="100" colspan="2">张三</td>
<td width="100" colspan="2">李四 </td>
<td width="100" colspan="2">王五</td>
<td width="100" colspan="2">赵六 </td>
<td width="100" colspan="2">里斯</td>
</tr>
<tr>
<td>国家及地区</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td> </tr>
<tr>
<td>1</td>
<td>美国</td>
<td width="52"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿根廷</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿富汗</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>伊拉克</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></body>
</html图片不行,这就是图片,忘高手们,看看
<table border="1">
<tr>
<th height="38" colspan="12">二0一二年叉车销售流向表</th>
</tr>
<tr>
<td width="27" rowspan="2" >序号</td>
<td width="112" height="26">业务员</td>
<td width="100" colspan="2">张三</td>
<td width="100" colspan="2">李四 </td>
<td width="100" colspan="2">王五</td>
<td width="100" colspan="2">赵六 </td>
<td width="100" colspan="2">里斯</td>
</tr>
<tr>
<td>国家及地区</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td>
<td width="50">订单</td>
<td width="50">发货</td> </tr>
<tr>
<td>1</td>
<td>美国</td>
<td width="52"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿根廷</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>阿富汗</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>伊拉克</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></body>
</html