ÓÐÒ»¸ö±ícard
ÁÐÊôÐÔ
(1)id
(2)acount //Ïû·Ñ½ð¶î
(3)asn //¿¨ºÅ
(4)consumtime //Ïû·Ñʱ¼ä
ÎÒÏë²éÕÒ£¬ÈÎÒâ10·ÖÖÓÖ®ÄÚ£¬ÕÒµ½Í¬Ò»ÕÅ¿¨£¬Ïû·Ñ½ð¶îÏàͬµÄÐÅÏ¢(¾ÍÊÇͬһÕÅ¿¨ÔÚÊ®·ÖÖÓÖ®ÄÚÏû·ÑÁËÏàͬµÄ½ð¶î)
Êä³ö¿¨ºÅºÍÏû·ÑÐÅÏ¢ÒÔ¼°Ïû·Ñʱ¼ä
ÎÒ֮ǰдµÄÊÇÕâÑù£¬ÎÒËæ±ã²éÕÒÁËÒ»¸öÈÕÆÚ
......
Òª²éѯÔÚÉ趨µÄÓÐ½ÏÆÚÄÚËùÓÐÉÌÆ·£¬Ã¿¼þÉÌÆ·µÄÓÐ½ÏÆÚÊDz»Ò»ÑùµÄ£¡Òª»ñÈ¡µ±Ç°Ê±¼äÀ´±È½Ï£¡
Çë¸ßÊÖÖ¸½Ì£¡
select * from tbgoods where time betwween in statetime and endtime
³ò³ò£¿ÎÒûд´í°É£¿
Çó³öÉÌÆ·ÖÐÓÐЧÆÚ×îСºÍ×î´óµÄ£¬È»ºóÔõô²Ù×÷¶¼ÐÐÁË`~
ÒªÓëϵͳµÄµ±Ç°Ê±¼ä±È½ÏµÄ£¡
SQL code:
select * f ......
Ò»¸öÓû§ÐÅÏ¢±í£¨id£¬mingzi£©£¬Ò»¸öÁôÑÔ±í£¨id£¬title£¬userid£©£¬Ò»¸ö»Ø¸´±í£¨id£¬lyid£¬userid£¬date£©£¬»Ø¸´±íºÍÁôÑÔ±íÖеÄuseridÓëÓû§±íÖеÄid¶ÔÓ¦£¬»Ø¸´±íÖеÄlyidÓëÁôÑÔ±íÖеÄidÏà¶ÔÓ¦¡£
ÏÖÔÚ¸ø³öÒ»¸öÓû§µÄid£¬Òª²é³öËûËù»Ø¸´µÄÁôÑÔ¡£Ã¿Ìõ¼Ç¼°üÀ¨ÁôÑÔtitle£¬·¢²¼ÈË£¬»Ø¸´Êý£¬×îºó¸üС£¸ÃÔõôд£¿
form µÄʱº ......
SQL code:
--²éѯij¸ö¿îËùÓгßÂëµÄ³ß´ç
select StyleNumberId ¿îºÅ,ClothingSitusName ²¿Î»Ãû³Æ,ClothingSize ³ßÂë,ClothingDimension ³ß吋
from vw_ClothingSize where StyleNumberId = 'P091127000150'
--vw_ClothingSize±íÊÓͼµÄÊý¾Ý
±à ºÅ ²¿Î»Ãû ³ßÂë ³ß´ç
P091127000150 ¼ç¿í M ......
±í READ
×Ö¶Î £º ID DATE MOUNT
01 1/2/2010 1
01 2/2/2010 2
01 3/2/2010 3
& ......
±íTÓÐÒ»¸ö×Ö¶ÎidÊÇintÐ͵ģ¬ÈçºÎÓÃsqlÓï¾äÀ´²éѯºÍ¸ø¶¨µÄij¸öÖµ×î½Ó½üµÄÖµ£¬
±È·½Ëµid£º2£¬4£¬5£¬6£¬7
Òª²é³öºÍ5×î½üµÄidµÄselectÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿
½ö¹©²Î¿¼
SELECT * from ID = (SELECT TOP(1)ID from (SELECT abs(ID-5) AS NUM,ID from T)ZZ ORDER BY NUM)
SQL code:
select top 1 id from [ ......