第二讲SQL高级查询技术.pdfVIP

SQL 2 2.1 UNION UNION SELECT UNION 1UNION 2 SELECT 3 UNIONORDER BY 4 ALL UNION SELECT UNION [ALL] SELECT UNION --Union Select * From StudScoreInfo Where StudScore=60 And StudScore=70 Union All Select * From StudScoreInfo Where StudScore=90 And StudScore=100 -- Select * From StudScoreInfo Where StudScore=90 And StudScore=100 or StudScore=60 And StudScore=70 -- Select StudName From StudInfo Where StudSex=‘’ Union Select CourseName From CourseInfo Union Select ClassName From ClassInfo Union Select as ,Count(*) From StudScoreInfo Where StudNo=20010505001 And StudScore=90 Union All Select as ,Count(*) From StudScoreInfo Where StudNo=20010505001 And StudScore=80 And StudScore90 Union All Select as ,Count(*) From StudScoreInfo Where StudNo=20010505001 And StudScore=70 And StudScore80 Union All Select as ,Count(*) From StudScoreInfo Where StudNo=20010505001 And StudScore=60 And StudScore70 Union All Select ‘’ as ,Count(*) From StudScoreInfo Where StudNo=20010505001 And StudScore60 2.2 Where -- Select * From StudInfo,StudScoreInfo Where StudInfo.StudNo=StudScoreInfo.StudNo -- Select StudInfo.StudNo,StudInfo.StudName,StudI n