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

  • 1
  • 0
  • 约1.35万字
  • 约 47页
  • 2019-03-02 发布于未知
  • 举报
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

您可能关注的文档

文档评论(0)

1亿VIP精品文档

相关文档