ÇóÖúÒ»¾äSQLÓï¾ä

Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float

Êý¾ÝÈçÏ£º

Code      CreateTime          Price
031002 2008-10-17 15:00:15    3.58
031012 2008-10-17 15:00:16    5.53
031022 2008-10-17 15:00:17    4.54
031032 2008-10-17 15:00:18    3.51
031013 2008-10-17 15:00:19    3.52
031023 2008-10-17 15:00:20    2.50
031033 2008-10-17 15:00:21    4.53
031054 2008-10-17 15:00:22    3.55
031004 2008-10-17 15:00:23    3.55
031024 2008-10-17 15:00:24    5.57

ÎÒ²éѯ
SELECT * from Table Where Price between 4 and 5
³öÀ´µÄ½á¹ûÊÇ

031022 2008-10-17 15:00:17    4.54
031033 2008-10-17 15:00:21    4.53

ÎÒÏëÒªµÄ½á¹ûÊÇ

031032 2008-10-17 15:00:18    3.51
031054 2008-10-17 15:00:22    3.55

¾ÍÊÇ˵Ҫ·ûºÏ²éѯµÄÌõ¼þµÄÏÂÒ»Ìõ£¬Ëû±¾ÌõÌø¹ý£¬ÇëÎÊÕâ¾äSQLÒªÔõôд£¬Ð»Ð»£¡

---

SQL code:
SELECT *,(select count(1) from [table] where Code<=T.code) as id into #temp from [Table] t Where Price between 4 and 5

select * from #temp t where
exists (SELECT 1 from #temp Where Price betw