LoveBeyond
y1d2y3xyz · 共 110 篇文章
SQL整理五
学生信息表:tab1 +------+--------+-----+ |name class score +------+--------+-----+ | 张三 法学02班 59 +------+--------+-----+ | 李四 公商00班 69 +------+--------+-----+ | 王五 法学02班 95 +------+--------+-----+ | 马六 公商00班 65 +------+--------+-----+ | 阿一 法学02班 88 +------+--------+-----+ | 阿洒 公商00班 66 +------+--------+-…
2009-07-04 11:37 · SQL · 评论(0)
SQL整理四
学生表:xstudent +-------+------+------+----------+-------+ |(学生ID) (名字) (性别) (生日) (班级) +-------+------+------+----------+-------+ |xsid xsnm xssex xsbirthday sclass +-------+------+------+----------+-------+ |108 曾华 男 09/01/77 95033 +-------+------+------+----------+-------+ |105 匡明 男 10/02/75 95031 +…
2009-07-04 11:13 · SQL · 评论(0)
SQL整理三
产品信息表:product +--+-----+-------+------+ |id| name| p_name| p_num| +--+-----+-------+------+ |1 | A | 商品甲 | 2 | +--+-----+-------+------+ |2 | B | 商品乙 | 4 | +--+-----+-------+------+ |3 | C | 商品丙 | 1 | +--+-----+-------+------+ |4 | A | 商品丁 | 2 | +--+-----+-------+------+ |5 | B | 商品丙 | 5 | +--+----…
2009-07-04 08:42 · SQL · 评论(0)
SQL整理二
显示下表年度为季度,算出总计 表income +----+------+---------+-----------+ | id | year | quarter | amount | +----+------+---------+-----------+ | 1 | 2004 | 1 | 2328.00 | | 2 | 2004 | 2 | 3822.00 | | 3 | 2004 | 3 | 7071.00 | | 4 | 2004 | 4 | 8931.00 | | 5 | 2005 | 1 | 2633.00 | | 6 | 2005 | 2 | 3910.00 | | 7 | 200…
2009-07-03 21:05 · SQL · 评论(0)
SQL整理一
部门信息:dept +------+-----------+------------+ |deptno| deptname |deptlocation| +------+-----------+------------+ | 1 |designing | workin121 | +------+-----------+------------+ | 2 | coding | workin123 | +------+-----------+------------+ | 3 | testing | workin125 | +------+-----------+------------+ | …
2009-07-03 17:22 · SQL · 评论(0)