2019年6月23日

like
摘要： select sname from teacher where sname like "q%"select sname from teacher where sname like "%an%"select sname from teacher where sname like "%ang" show 阅读全文
posted @ 2019-06-23 18:57 happygril3 阅读(107) 评论(0) 推荐(0)
case_when
摘要： 1. select sname,score, case when score>=20 and score<30 then 20 when score>=30 and score<40 then 30 when score<=40 and score<50 then 40 else 50 end as 阅读全文
posted @ 2019-06-23 18:56 happygril3 阅读(155) 评论(0) 推荐(0)

导航