microolap
箭头指向1的一方
一个表 由两个出发 一定是多对多联系 (有2个外键 )
//生成一个虚拟的视图
create view students
as
select a.stu_id id , a.stu_name name, b.subject , b.subject_eng
from t_student a
inner join t_class b on a.cls_id = b.cls_id
//可以在视图里面查询数据
//简化了代码 会造成性能浪费,牺牲了性能
distinct 唯一
count(*) // 列相同的进行分组,算出有多少个
GROUP BY
COUNT(DISTINCT[column])
SUM()
AVG()
MAX()
SID_DEV()//标准方差
NOW()
CURDATE()
TIMESTAMPADIFF() //可以计算年龄
select
a.stu_id,
a.stu_name,
count(*),
count(distinct b.course_id)
from t_student a
inner join t_mark b on a.stu_id = b.stu_id
inner join t_class c on c.cls_id = a.cls_id
where b.scroll < 60 and c.subject_eng = '会计' and c.subject = '2012'
group by a.stu_id, a.stu_name