a393060727-陈惟鲜的博客

摘要： 用DECODE 或用交叉报表实现报表横向显示CREATE TABLE LL (ART_NO VARCHAR2(3),NAME VARCHAR2(4),SALES VARCHAR2(4));INSERT INTO LL VALUES(101,'A1',200);INSERT INTO LL VALUES(102,'B1',400);INSERT INTO LL VALUES(103,'C1',600);INSERT INTO LL VALUES(104,'D1',800);COMMITSELECT NO,MAX(N101) AS & 阅读全文

摘要： 这个，以前很纠结，现在感觉我会用了，于是写出来。语法：select CASE WHEN条件 THEN 执行表结构：课程表：CREATE TABLE `course` ( `courseid` int(10) NOT NULL, `name` varchar(20) default NULL, PRIMARY KEY (`courseid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;成绩表：CREATE TABLE `user_score` ( `userid` int(10) NOT NULL default '0', `courseid` in 阅读全文