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

sql±à¼­¹¤¾ß

´ó¼Ò¶¼ÓÃʲôsqlÓï¾ä±à¼­¹¤¾ß£¡»¹ÊÇÖ»½ÓÓòéѯ·ÖÎöÆ÷£¿ÍøÉÏÕÒÁËЩPL/SQL developerÕâºÃÏñÊÇÁ¬OraclerµÄ
ÎÒÖ»ÏëÒª¸öSQl±à¼­¹¤¾ß
SSMS.

²éѯ·ÖÎöÆ÷×ã¹»ÁË

±¾ÈË×î½üÔÚѧϰsql
µ«Ã¿´Î¶¼ÒªÍù²éѯ·ÖÎöÆ÷ÉÏÌù
  ¶øÇÒ×ÖÌåºÜС

²éѯ·ÖÎöÆ÷

²Î¿¼´ËÌùhttp://topic.csdn.net/u/20091007/20/e4b03891-12ea-4ffb-bbbd-d65497d5fc85.html?55649

ÆäʵÈç¹ûÄã×ö.netµÄ»°£¬¿ÉÒÔÓÃһϣº¶¯Èí.net´úÂëÉú³ÉÆ÷£¬ÀïÃæ¿ÉÒÔÁ¬¸÷ÖÖÊý¾Ý¿â£¬×öÊý¾Ý¿âºÜ·½±ã¡£²»×ö.netÆäʵҲ¿ÉÒÔÓ㬿ÉÒÔµ±×ö²éѯ·ÖÎöÆ÷Ó㬲»¹ý±ÈÄǶ«Î÷»¹ÊµÓÃЩ£¬¹¦Äܸü¶à£¬¸üÇ¿¡£¡£¡£


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

vbÖ´ÐÐaccess sqlÓï¾ä¹ÖÎÊÌâ

SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";

ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......

ÇósqlÓï¾äÀí½â

±íA
¿¨ºÅ        ʱ¼ä
1                null
2                null
3      ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ