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

¼òµ¥SQLÓïÑÔ - Delphi / Êý¾Ý¿âÏà¹Ø

Êý¾Ý£º Äê Ô ÈÕ ¿ªÅÌ ÊÕÅÌ
ʹÓÃÏÂÃæÓï¾äËÑË÷µ½ÁË Ã¿Äêÿ¸öÔµÄÔ³õºÍÔÂÄ©¶¼ÊǼ¸ºÅ  

select Äê,ÔÂ,MIN(ÈÕ) as frist,MAX(ÈÕ) AS laset from mt4his.DB GROUP BY Äê,ÔÂ

ÎÒÏëµÃµ½ ÿÄêÿ¸öÔµÄÔ³õºÍÔÂÄ© Ëù¶ÔÓ¦µÄ ¿ªÅÌ ÊÕÅÌ Ó¦¸ÃÔõôд


µÚÒ»Ì쿪Å̾ÍÊÇÕûÖÜÔÂÄêµÄ¿ªÅÌ£¬×îºóÒ»ÌìÊÕÅ̾ÍÊÇÕûÖÜÔÂÄêµÄÊÕÅÌ

´ó¸ÅÕâÑù(Ô³õ)
select Äê,ÔÂ,ÈÕ, ¿ªÅÌ, ÊÕÅÌ from mt4his.DB a,
(select Äê,ÔÂ,MIN(ÈÕ) as frist from from mt4his.DB GROUP BY Äê,ÔÂ) b
where a.Äê=b.Äê and a.ÔÂ=b.ÔÂ and a.ÈÕ=b.first




´ËÌù±Ø¶¥Ò»ÏÂ
¹ÉƱ

form12.Query1 .Close;
form12.Query1.DatabaseName:=(ExtractFilePath(ParamStr(0))+'TABLE');
form12.Query1.SQL.Clear;
form12.Query1.SQL.Add('select Äê,ÔÂ,ÈÕ, ¿ªÅÌ, ÊÕÅÌ from mt4his.DB a,(select Äê,ÔÂ,MIN(ÈÕ) as frist,MAX(ÈÕ) AS laset from mt4his.DB GROUP BY Äê,ÔÂ) b where a.Äê=b.Äê and a.ÔÂ=b.Ô and a.ÈÕ=b.first');
form12.Query1.Open;
--
ÏÔʾINVALID USE OF KEYWORD TOKEN:select

¼±Çó´ð°¸°¡

ÒªÊÇÄܵõ½ Äê,ÔÂ,ÈÕ, ¿ªÅÌ, ÊÕÅÌ,¿ªÅÌ-ÊÕÅ̾͸üºÃÁË

Ôΰ¡,ûעÒâÊÇparadoxÊý¾Ý¿â,ËüµÄSQL¹¦ÄÜÌ«ÓÐÏÞÁË...


http://download.csdn.net/source/1644211

paradoxµÄ»°,¸Ð¾õÖ»Äܶþ´Î²éѯÍê³É
select Äê,ÔÂ,MIN(ÈÕ) as frist,MAX(ÈÕ) AS laset from mt4his.DB GROUP BY Äê,ÔÂ
µÃµ½ Äê,ÔÂ,frist,laset
ÄÇôÿÄêÿ¸öÔµÄÔ³õËù¶ÔÓ¦µÄ ¿ªÅÌ ÊÕÅÌ
¶ÔÉÏÃæµÄ½á¹û×öÑ­»·:
µÃµ½1¸öÄê,ÔÂ,frist
select Äê,ÔÂ,¿ªÅÌ,ÊÕÅÌ from ±í where Äê="ÉÏÃæµÄ


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

delphiÈçºÎ±¸·ÝorcalÊý¾Ý¿â£¿ - Delphi / Êý¾Ý¿âÏà¹Ø

³ÌÐòʹÓõÄÊÇOrcalÊý¾Ý¿â£¬Ï붨ÆÚ£¨Ã¿¼¾¶È£©¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬Ã»É¶Í·Ð÷£¬ÇëÎÊÓ¦¸ÃÔõôŪ£¿
ÓÐÊ²Ã´ÌØÊâÒªÇóÂ𣬱ÈÈçҪǰ¶Ë½çÃæ£¿
Ò»°ãÓÃÊý¾Ý¿â×Ô´øµÄ¡°¼Æ»®ÈÎÎñ¡±ÅäÖÃһϾ͹»ÁË

ûÓÐÊ²Ã´ÌØÊâÒªÇó¡£ÀýÈ磬ֻҪµ ......

ÇóÒ»SQLд·¨ - MS-SQL Server / »ù´¡Àà

id                           url                   rank     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ