Çë½ÌÕâÑùµÄSQLÔõôд
±í: group value 1 1 1 2 1 3 2 1 2 3 3 1 3 3 ÿһ×éÖÐ(id)ȡһ¸öÖµ, ÎÒÏëµÃµ½¾¡Á¿²»Öظ´ÅÅÁеÄÒ»×é×éºÏ ÈçÉÏÀýÏëµÃµ½½á¹û: 1 2 2 1 3 3 лл
¿´²»³ö¹æÔò¡£Ã»ÓйæÔò£¬Ôõô¹¹ÔìsqlÓï¾äÄØ ÕæµÄ¿´²»³öÒ»µãµÄ¹æÂÉŶ,ÄÇÈç¹ûÓеÚËÄÐÐÓÖÊÇÔõÑùÄØ? ???¹æÔò¾ÍÊÇÕÒÿ×éÖ®¼ä¶¼²»Öظ´µÄÊý¾Ýѽ ²»Öظ´µÄ×éºÏÌ«¶àÁË£¬Äã¸ø³öµÄÕâÖÖ×éºÏºÁÎÞ¹æÂÉ¡£ÒýÓà ²»Öظ´µÄ×éºÏÌ«¶àÁË£¬Äã¸ø³öµÄÕâÖÖ×éºÏºÁÎÞ¹æÂÉ¡£ Ôõô¿ÉÄÜÌ«¶àÄØ?¶¥¶à»¹ÓÐÒ»×éÊÇ group value ----------- ----------- 1 2 2 3 3 1 µ«×îºÃ»¹ÄÜÅÅÐò:) ËùÒÔÊÇ: group value ----------- ----------- 1 2 2 1 3 3 group value 1 1 1 2 1 3 2  
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......