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

PL/SQLÈçºÎÉèÖÃÊôÐÔ£¬Ê¹ÆäÄÜ×Ô¶¯Ê¶±ð±íÃû

±ÈÈç˵£¬µ±ÎÒÔÚSQL±à¼­ÇøÊäÈëYS_£¬ÄÇôPL/SQL×Ô¶¯½«Êý¾Ý¿âÖпɱ»·ÃÎÊÇÒ±íÃûÒÔYS_¿ªÊ¼µÄ±íÈ«²¿ÏÔʾ³öÀ´
ûÉèÖÃ,¾ÍÄÜ´ïµ½ÄãÕâÑùµÄЧ¹û.¹À¼ÆÄ¬ÈÏÉèÖþÍÊÇÕâÑùµÄ

ĬÈÏÉèÖþÍÊÇÕâÑùµÄ£¬»á×Ô¶¯µ¯³öÒ»ÁбíÃ÷×ÖÈÃÄãÑ¡ÔñµÄ¡£

ĬÈÏÉèÖþͿÉÒÔ´ïµ½ÄãµÄÒªÇó°Ñ

ÒýÓÃ
ĬÈÏÉèÖþÍÊÇÕâÑùµÄ£¬»á×Ô¶¯µ¯³öÒ»ÁбíÃ÷×ÖÈÃÄãÑ¡ÔñµÄ¡£


ÊÇÕâÑùµÄ

F6

SQL code:
ĬÈϾÍÊÇÕâÑùµÄЧ¹û¡£



Ïà¹ØÎÊ´ð£º

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

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

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

¹ØÓÚ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 Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ