Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µÄÊǵڼ¸Ìõ¼Ç¼µÄ»°
delete from table1 where rowid in 
  (select rd from (
  select rowid rd,rownum rn from table1)
  where rn>=21 and rn<=30)

ѧϰ¡£¡£¡£



delete from table1 where rn in 
  (
  select rn 
  from 
  ( 
  select row_number() over(partition by ??(ÄãÒªÅÅÐòµÄ×Ö¶Î) rn order by rowid 
  from table1
  ) 
  where rn>=21 and rn <=30
  )

up


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
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:    ......

myeclipseÖÐÈçºÎÓëSQL server2008 Á¬½Ó

ÔÚ΢Èí¹Ù·½ÏÂÔØÁËÒ»¸ösqljdbc_2.0Çý¶¯°ü£¬ÏëÓÃsqlserver2008Á¬½Ó¡£µ«×ÜÊÇÔÚÁ¬½ÓÊý¾Ý¿âʱÌáʾ³ö´í£¨ÓÐÒ»µãҪ˵Ã÷µÄÊÇÎҵĵçÄÔÀïÓÐÁ½¸öÊý¾Ý¿â°æ±¾Ò»¸öÊÇsqlserver2005(ĬÈϵÄʵÀý)»¹ÓÐÒ»¸ö¾ÍÊÇsqlserver2008(ÐèÒªÖ¸¶¨Ê ......

ÇóÒ»ÌõSQLÓï¾ä¡£

ID  ²Í±ð    ʱ¼ä
1  ÖÐ²Í 2009-10-25
2  ÖÐ²Í 2009-10-26
3  Íí²Í 2009-10-26
4  Ôç²Í 2009-10-27

½á¹û
1  ÖÐ²Í 2009-10-25
3  Íí²Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ