数据库管理实验报告

结果 例3.21 SELECT SNO FROM\ 结果SELECT Distinct SNO FROM\ 结果 例3.22 SELECT SNAME FROM\WHERE SDEPT='CS'; 结果例3.23 SELECT SNAME,SAGe FROM\WHERE sage<20; 结果 例3.24 SELECT DISTINCT sno FROM\结果 例3.25 SELECT SNAME,SDEPT,SAGE FROM\结果

例3.26 SELECT SNAME,SDEPT,SAGE FROM\结果 例3.27 SELECT SNAME,Ssex FROM\WHERE sdept in ('CS','MA','IS'); 结果 例3.28 SELECT SNAME,Ssex FROM\WHERE sdept not in ('CS','MA','IS'); 结果 例3.29 SELECT* FROM\结果 例3.30 SELECT sname,sno,ssex FROM\刘%'; 结果 例3.31 SELECT sname FROM\欧阳-'; 结果 例3.32 SELECT sname,sno FROM\where sname like '-阳%';

结果 例3.33 SELECT sname,sno,ssex FROM\where sname not like '刘%'; 结果例3.34 SELECT cno,ccredit FROM\where Cname like'DB\\_DESIGN' ESCAPE'\\'; 结果 例3.35 SELECT* FROM\where Cname like'DB\\_%i_ _'ESCAPE'\\'; 例3.36 SELECT sno,cno FROM\where grade is null; 结果例3.37 SELECT sno,cno FROM\where grade is NOT null; 结果 例3.38 SELECT sname FROM\where SDEPT='CS' AND SAGE<20;

结果例3.39 SELECT sno,grade FROM\where cno='3' order by grade desc; 结果SELECT sno,grade FROM\where cno='3' order by grade; 结果 例3.40 SELECT* FROM\order by sdept,sage desc; 结果 例3.41 SELECT COUNT(*) FROM\ 结果 例3.42 SELECT COUNT(DISTINCT SNO) FROM\结果例3.43 SELECT AVG(GRADE) FROM\WHERE CNO='1';