SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * from
±íA ,±íB ,±íC , ±íD, ±íE
Where ÆäËûÌõ¼þ and ±íA.id || ' ' =±íB.id
Èç¹û¸÷ÖÖÌõ¼þÊÇÒ»ÖµĻ°£¬ÄÚÁ¬½ÓÊÇ×î¿ìµÄ¡£¼´µÚ¶þÖÖ·½·¨
µÚ¶þÖÖÊÇËûÃÇÌṩҪ¸Ä½øµÄ·½Ê½£¬Êý¾ÝÌ«¶à¡£
Ҫд·ÖÎöÔÒò£¬¾ÍÊÇҪд³öΪʲô¸Ä½øÖ®ºóËٶȻá´ó·ù¶ÈÌá¸ß¡£
ÀíÂÛÉϽ²£¬Á¬½ÓÖÐÄÚÁ¬½ÓÊÇ×î¿ìµÄ£¬ÒòΪֻÓзûºÏÌõ¼þµÄ¼Ç¼²Å»áɸѡ³öÀ´
from
( "A"
LEFT OUTER JOIN "B" ON ( "A"."id" = "B"."id" ) )
LEFT OUTER JOIN "C" ON ( "A"."id" = "C"."id" ), "D"
WHERE
"A"."Äê·Ý" = ?
AND "A"."Ãû³Æ" = "D"."Ãû³Æ"
AND "A"."ºÅÂë1" = "D"."ºÅÂë1"
AND "A"."ºÅÂë2" = "D"."ºÅÂë2"
AND "A"."id" = "D"."id"
..............................................
from "A" INNER JOIN "D" ON ( "A"."Ãû³Æ" = "EDA"."Ãû³Æ"
AND "A"."ºÅÂë1" = &q
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......