sql¸ß¼¶²éѯ - Web ¿ª·¢ / ASP

Ï뼸¾ä´úÂë¸ã¶¨ÏÂÃæµÄ²éѯ

Êý¾Ý¿âÓÐÒ»×Ö¶Î,Êý×ÖÇÒ²»ÄÜÏàͬ

µ±²åÈëֵΪ1000µÄʱºò,²éѯÊý¾Ý¿â,ÓÐÎÞ1000,û,¾Í²åÈë1000,ÓоͲéѯÊÇ·ñÓÐ1000.1,ÈçÎ޾ͲåÈë1000.1,ÈçÓÐ1000.1¾Í²åÈë1000.2,ÒÀ´ÎÀàÍÆ(˵°×Á˾ÍÊÇ,ÓÐÏàͬµÄ¾Í¼Ó0.1,ÇÒ²»ÄÜÖظ´)

---

ÏȲéѯ ´óÓÚµÈÓÚ10000µÄÒ»Ìõ È»ºó+0.1¾Í¿ÉÒÔÁË ÔÚ¸üÐÂ

---

¹Ø¼üÊDz»ÄÜÖظ´


Êý¾Ý¿âÄÚ¿ÉÄÜÒѾ­ÓÐÁË1000.1ÕâÌõ¼Ç¼

---

sql="SELECT MAX([×Ö¶Î]) from ±í WHERE [×Ö¶Î]>=1000"
set rs=conn.execute(sql)
if rs.EOF then
  дÈë1000µÄÊý¾Ý
else
  a=cdbl(rs(0))+0.1
  дÈëÊý¾Ýa
end if

---

ÒýÓÃ

¹Ø¼üÊDz»ÄÜÖظ´


Êý¾Ý¿âÄÚ¿ÉÄÜÒѾ­ÓÐÁË1000.1ÕâÌõ¼Ç¼

=======================
Êý¾Ý¿âÀïµÄÖµ 10000 10000.1 10000.2 10000.3 

µ±Ç°²åÈëÊýÖµ10001
ÏȲéѯ µÈÓÚ »ò ´óÓÚ10000µÄÒ»Ìõ ²é³ö10000.3
È»ºó+0.1 ¾ÍÊÇ 10000.4

---

¶î.. Ó¦¸ÃÊÇÏȲéѯ´óÓÚµÄÒ»Ìõ Èç¹ûûÓÐ Ôھ͵ÈÓÚµÄ Èç¹ûûÓоÍÖ±½Ó²åÈë
 
È»ºóÔÚ¼Ó0.1

---

ÓÃÍò¶ñµÄµÝ¹é°É

---

ÒýÓÃ

sql="SELECT MAX([×Ö¶Î]) from ±í WHERE [×Ö¶Î]>=1000"
set rs=conn.execute(sql)
if rs.EOF then
дÈë1000µÄÊý¾Ý
else
a=cdbl(rs(0))+0.1
дÈëÊý¾Ýa
end if

Èç¹ûÊý¾Ý¿âÀïÓÐÒ»Ìõ1000000000000µÄ×î´ó¼Ç¼,ÄÇôִÐÐÏÂÀ´¾ÍÒª²åÈë1000000000000.1ÁË...

Ö»Ïë²åÈëÒ»Ìõ×î½üµÄ¼Ç¼,Çв»ÖØ