sqlÓï¾äµÄÖ´ÐÐ˳ÐòʵÀý½²½â
±ê׼˳ÐòµÄ SQL Óï¾äΪ:
Select ¿¼ÉúÐÕÃû, max(×ܳɼ¨) as max×ܳɼ¨
from tb_Grade
where ¿¼ÉúÐÕÃû is not null
group by ¿¼ÉúÐÕÃû
having max(×ܳɼ¨) > 600
order by max×ܳɼ¨
ÔÚÉÏÃæµÄʾÀýÖÐ SQL Óï¾äµÄÖ´ÐÐ˳ÐòÈçÏÂ:
(1). Ê×ÏÈÖ´ÐÐ from ×Ó¾ä, ´Ó tb_Grade ±í×é×°Êý¾ÝÔ´µÄÊý¾Ý
(2). Ö´ÐÐ WHERE ×Ó¾ä, ɸѡ tb_Grade ±íÖÐËùÓÐÊý¾Ý²»Îª NULL µÄÊý¾Ý
(3). Ö´ÐÐ GROUP BY ×Ó¾ä, °Ñ tb_Grade ±í°´ "ѧÉúÐÕÃû" ÁнøÐзÖ×é
(4). ¼ÆËã max() ¾Û¼¯º¯Êý, °´ "×ܳɼ¨" Çó³ö×ܳɼ¨ÖÐ×î´óµÄһЩÊýÖµ
(5). Ö´ÐÐ HAVING ×Ó¾ä, ɸѡ¿Î³ÌµÄ×ܳɼ¨´óÓÚ 600 ·ÖµÄ.
(7). Ö´ÐÐ ORDER BY ×Ó¾ä, °Ñ×îºóµÄ½á¹û°´ "Max ³É¼¨" ½øÐÐÅÅÐò.
Ïà¹ØÎĵµ£º
×¼±¸¹¤×÷£ºÊý¾ÝÇåÏ´¡£¼ì²éÊý¾ÝÀàÐͺͱíÖеÄ×Ö¶ÎÀàÐÍÊÇ·ñÆ¥Å䣻¼ì²é¿ÕÖµÔ¼Êø£»È¥Î޹ؿոñµÈ¡£ÕâЩ¼ì²é¹¤×÷¿ÉÒÔͨ¹ýExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬¿´Ò»ÏÂÿ¸ö×Ö¶ÎËùÓеÄÖµ£¬ÔÙÑ¡Öв»ºÏ¹æ·¶µÄ½øÐÐÐ޸ġ£
²½Ö裺
1£©µÇ¼pl/sql developer£¬µÇ¼ʱѡÔñ´ýµ¼Èë±íËùÔÚÊý¾Ý¿â£¬ÔÚ²éѯ´°¿ÚÀïÊäÈësele ......
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÀïÑ¡Ôñ“SQL ServerºÍWindows É ......
SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......
1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select
emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
¡¡¡¡
2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐÔ±ð¡ ......