sql server ³¬Ê±ÎÊÌâ
ÕýÔÚ×ösql server 2000Êý¾Ý¿â¿ª·¢£¬Êý¾Ý¿â¼Ç¼ÊýºÜ¶à£¬¶à´ïǧÍòÌõ£¬Öظ´µÄÒ²ºÜ¶à£¬ÓÃgroup byдÁËÒ»ÌõÈ¥ÖØµÄÓï¾ä£¬delete from table where (id not in (select min(id) from table group by ×Ö¶Î1))
Óòéѯ·ÖÎöÆ÷Ö´ÐÐÒª2¸ö¶àСʱ¿ÉÒÔÖ´Ðгɹ¦£¬µ«ÊÇÓÃÆóÒµ¹ÜÀíÆ÷Ö´ÐÐ×ÜÊDZ¨³¬Ê±£¬µÇ½ʱ¼äºÍ²éѯʱ¼ä¶¼ÉèÖùýÁË£¬Ëƺõûʲô¹ØÏµ£¬ÄÄλ¸ßÊÖÖªµÀÊÇʲôÎÊÌâ°¡£¡»¹ÓÐÒ»¸öÎÊÌ⣬»ùÓÚADOµÄvc±à³Ì£¬Í¬ÑùÊäÈëÉÏÃæµÄÄÇÌõÓï¾ä£¬Ò²±¨³¬Ê±,ллÁË
id ×ֶμӸöË÷ÒýÊÔÊÔ¡£¡£
Óõ½in , not inµÄ²éѯÊǿ첻ÆðÀ´µÄ.
vcÄDZ߽â¾öÁË£¬Í¨¹ýconnectiontimeoutºÍcommandtimmeoutÉ趨ʱ¼äΪ0,ûÓгöÏÖ³¬Ê±µÄÎÊÌ⣬¼ÓË÷ÒýÓ¦¸Ã¿ÉÒÔ¼Ó¿ì²éѯËÙ¶È£¬2Â¥µÄÄÇ룬ÇëÎÊÓÐʲôºÃµÄ½¨Òéû£¬²»Ê¹ÓÃinºÍnot in£¬¶ÔÓÚÆóÒµ¹ÜÀíÆ÷³öÏÖ³¬Ê±£¬¶ø²éѯ·ÖÎöÆ÷²»³öÏÖµÄÎÊÌ⣬ÈÔÈ»ºÜÄÉÃÆ£¬»¹Ã»Óнâ¾ö
SQL code:
delete K
from table K
where id <>(select min(id) from table where k.×Ö¶Î1=×Ö¶Î1)
ÕâÑùÒ²¿ì
SQL code:
delete K
from table K
where exists (select * from table where k.×Ö¶Î1=×Ö¶Î1 and k.id>id)
¸öÈËϰ¹ßÓÃÁ´½Ó·½Ê½
ѧϰÖС£¡£¡£Ð»Ð»¸÷λÁË£¡
ѧϰ
Ïà¹ØÎÊ´ð£º
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
SQL code:
declare @t varchar(5000)
set @t=''
select @t=@t+',[È¡Ïû·ÖÎö-'+quXiaoFenXi+']=sum(case when [quXiaoFenXi]='+quotename([quXiaoFenXi],'''')+' then shangPinZongShu else 0 end)'
from tb_gyyD ......