Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Äê="ÉÏÃæµÄ


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

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

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

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

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

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