【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-select.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
SELECT * FROM student
SELECT sName,sSex,sAddress FROM student
SELECT sName AS ,sSex AS 性别,sAddress AS 地址 FROM student
SELECT sName AS ,sPhone AS 电话 FROM student WHERE sSEX = '男'
SELECT sName AS ,sPhone AS 电话 FROM student WHERE sName LIKE '李%'
SELECT stuID,courseID FROM stuCourse WHERE stuMark BETWEEN 60 AND 80
SELECT ID,sName FROM student WHERE ID NOT IN (SELECT stuID FROM stuCourse)
SELECT * FROM stuCourse WHERE stuMark > 60 ORDER BY stuMark DESC
SELECT stuCourse.stuMark AS 分数,course.cName AS 课程 FROM stuCourse,course
WHERE stuCourse.courseID = course.ID AND stuCourse.stuID = '200131500141'
SELECT A.stuMark AS 分数,B.cName AS
课程 FROM stuCourse AS A,course AS B
WHERE A.courseID = B.ID AND A.stuID = '200131500141'
SELECT A.ID,A.sName,B.courseID,B.stuMark FROM student AS A
LEFT JOIN stuCourse AS B ON A.ID = B.stuID