·¢²¼Ê±¼ä : ÐÇÆÚÁù ÎÄÕÂÊý¾Ý¿âʵÑéËÄ£ºSQLÊý¾Ý²éѯ¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ
select * from Ñ¡¿Î --½µÐò order by ³É¼¨ desc
£¨14£©²éѯ½á¹û°´¶àÁÐÅÅÐò£¬²¢·Ö±ðÒªÇóÉýÐòºÍ½µÐòµÄ²éѯ¡£ select * from Ñ¡¿Î
order by ѧºÅ, ³É¼¨
select * from Ñ¡¿Î order by ѧºÅ, ³É¼¨ desc
£¨15£©Ê¹ÓÃTOPÏÔʾǰÈô¸É¼Ç¼µÄ²éѯ select top 3 * from ѧÉú
£¨16£©Ê¹ÓÃTOPÏÔʾǰÈô¸É¼Ç¼µÄ²éѯ£¬Èç¹ûÓÐÂú×ãÌõ¼þµÄ²¢ÁмǼһ²¢ÏÔʾ select top 3 * from ѧÉú where ÉúÔ´='»´ÄÏ'
£¨17£©Á½¸ö¹ØϵµÄÁ¬½Ó²éѯ¡£
select * from ѧÉú cross join Ñ¡¿Î
£¨18£©´øÆäËû²éѯÌõ¼þµÄÁ½¸ö¹ØϵµÄÁ¬½Ó²éѯ
select ѧÉú.ѧºÅ,Ժϵ,ÐÕÃû,ÐÔ±ð,ÉúÔ´,¿Î³Ì±àºÅ,³É¼¨ from ѧÉú join Ñ¡¿Î on Ñ¡¿Î.ѧºÅ= ѧÉú.ѧºÅ