1. select å¦å·,å§å from Table_stu stu join Table_Sc sc on stu.no=sc.no
join Table_Course c on c.number=sc.number where 课ç¨å='JAVA'
2. select 课ç¨å from Table_stu stu join Table_Sc sc on stu.no=sc.no
join Table_Course c on c.number=sc.number where å§å='ä¾ä¾'
3. select å¦å·,å§å from Table_stu stu join Table_Sc sc on stu.no=sc.no
join Table_Course c on c.number=sc.number group by å¦å·,å§å
having count(å¦å·)=5
4. select top 5 * from Table_Sc
5. select top 5 * from Table_Sc where NO not in
(select top 5 NO from Table_Sc order by chenji) order by chenji
6. select name,class,max(chenji) from Table_stu stu
join Table_Sc sc on stu.no=sc.no
join Table_Course c on c.number=sc.number
group by name,class
7. select getdate()
没ææµè¯ï¼åªæ¯åä½ çé®é¢åå¾çååºãå¯è½ä½ éè¦ä¿®æ¹ã