一只小白two

摘要：select dname,count(ename),avg(sal),sum(sal) from emp e,dept d where e.deptno=d.deptno group by dname; select dname,count(ename),avg(sal),sum(sal) from 阅读全文

摘要：列转行CREATE TABLE sdb.t_col_row(id int, c1 varchar(10), c2 varchar(10), c3 varchar(10)) INSERT INTO sdb.t_col_row( id, c1, c2, c3)VALUES (1, 'v11', 'v21 阅读全文

摘要：学生表 Studentcreate table Student(Sid varchar(6), Sname varchar(10), Sage datetime, Ssex varchar(10));insert into Student values('01' , '赵雷' , '1990-01- 阅读全文