sql ²éѯ - MS-SQL Server / »ù´¡Àà
ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ Óï¾äÈçÏ£º SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ£© from TABLEA B WHERE A.ÎïÁϱàÂë=B.ÎïÁϱàÂë GROUP BY ÎïÁϱàÂë) ²éѯ½á¹û¿ÉÒÔ²éѯ³ö£¬µ«ÊDzéѯËٶȹýÂý£¬ÎҵIJéѯ¼Ç¼ÓÐ10¶àÍòÌõ£¬°ë¸öСʱ²»³ö½á¹û£¬ÓÐûÓÐÖ´ÐÐËٶȱȽϿìµÄÓï¾ä¡£
ÔÚÈë庫ÈÕÆÚ 與ÎïÁÏ編碼 ÉϽ¨Á¢Ë÷ÒýÁË嗎£¿ ¼Ó¼ÓË÷ÒýÊÔÊÔ£¬¹À¼Æ¼ÓË÷ÒýÒ²µÃÒªÒ»»á¶ù ÎïÁϱàÂë¼ÓË÷Òý Èë¿âÈÕÆÚºÍÎïÁϱàÂë¼ÓË÷Òý SQL code: TRY: CREATE INDEX IDX_tablea_Èë¿âÈÕÆÚ ON TABLEA(Èë¿âÈÕÆÚ) GO SELECT ²É¹ºµ¥ºÅ,ÐкÅ,ÎïÁϱàÂë,Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ) from TABLEA B WHERE A.ÎïÁϱàÂë=B.ÎïÁϱàÂë)--È¥µôGROUP¡¡BY Èë¿âÈÕÆÚºÍÎïÁϱàÂë¼ÓË÷ÒýÒýÓà Èë¿âÈÕÆÚºÍÎïÁϱàÂë¼ÓË÷Òý ¶ÔÁË£¬»¹µÃ¶ÔÎïÁϱàÂë¼Ó¸öË÷ÒýÒýÓà ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ Óï¾äÈçÏ£º SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ£© from TABLEA B WHERE A.ÎïÁϱàÂë=B.ÎïÁϱàÂë GROUP BY ÎïÁϱàÂë) ²éѯ½á¹û¿ÉÒÔ²éѯ³ö£¬µ«ÊDzéѯËÙ¡
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£ MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10. ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨) from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨ from SC&n ......
ÓÐ2¸öÊý¾Ý±íAÓëB£¬ÈçºÎ²¹³äAÖÐûÓÐ,BÖÐÓеÄÊý¾Ý£¬Ê¹A±íÊý¾ÝÍêÕû£¿ÇëдϾßÌåÔ´´úÂë SQL code: insert A select * from A right join B on A.key=b.key where A.key is null select * from B left join ......