SQL实验报告实验三.docx

SQL实验报告实验三.docx1•打开数据库SQLServer2000的查询分析器,用CreateTable建表SCI。・(L..dministrator(54))*| ▼XEcreatetablesol(snochar(5)renochar(5)9L gradeint);◎一— m區结果命令已成功完成。4►©1(local)()PC-20130924ACEK\Admini...00:00:000行SQLQuery2sql-((.administrator(56))*altertablestudentaltercolumnsageintnr肉消息命令已成功完成:・(l^dministrator(56))*select*fromstudent;e1I200215121i李勇禺20csNULL2200215122刘晨女19csNULL3200215123王敏女18maNULL4200215124张立男19isNULLJ结果消息SQLQuery2sql-^.administrator(56))*altertablestudentaltercolumnsageintnr矗消息命令已成功尧成;SQLQuery2sql・0^dministrator(56))*createuniqueindexindexss|onstudent();<| rrr鬲7肖息命令已成功完成0lzlcrhmadltka^\…:": ..SQLQuery2>sql-^administrator(56))*dropindexindexsonstudent;|< rrr鬲7肖息命令已成功完成***@-20130924ACEK\Admini...秦延龙I00:00:00I0行(二)・(l...dministrator(56))*select*fromstudent;|・(l.^.dministrator(56))*selectdistinctsnofromsc;结果消息sno2002151212 ・(l...dministrator(56))*<90|;-^administrator(56))衰□selectsnorsnamefromstudentLwhereadeptin(1ma1r1is1r1csl1);rrrsnosname1:-(l^dministrator(56))齐 !□selectsno,,]%1;|・(l...dministrator(56))*E]amelike1db\_design1一escape1\1;|nr结果丄」-(l...dministrator(56))*| "X日selectsnoz|gradefromsc o=131Lorderbygradedesc;°I JE□结果A肖息snograde1200215121882 200215122 -(l^dministrator(56))*□select卜1AX(grad亡),最高分■fromscI-o=f11;塾结果區消息最高分J_92 j©|(local)()|PC:20130924ACEK\Admini...|秦包|00:00:001行/SQLQuery2sql・0^dministrator(56))* T:Bselecteno,COUNT(sno)fromsc -Lgroupbyeno;rn□结果由消息enoGE列名)1I1I1222332/SQLQuery2sql-0Mdministrator(56)尸□.*fromstudent9scLwherestudent•sno=sc•sno;