09 2020 档案
摘要:1、查询“001”课程比“002”课程成绩高的所有学生的学号 select * from Student where SNO in (select a.Sno from (select Sno,score from SC WHERE CNO ='001') a ,(select Sno,score
阅读全文
摘要:来自:https://blog.csdn.net/lukabruce/article/details/80568796 【注意】:Oracle数据库支持full join,mysql是不支持full join的,但仍然可以同过左外连接+ union+右外连接实现 查看mysql的版本;select
阅读全文
摘要:DROP TABLE IF EXISTS `imooc_goddess`; CREATE TABLE `imooc_goddess` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(30) NOT NULL, `sex` int
阅读全文