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ÆäʵҲ¿ÉÒÔÓ㬿ÉÒÔµ±×ö²éѯ·ÖÎöÆ÷Ó㬲»¹ý±ÈÄǶ«Î÷»¹ÊµÓÃЩ£¬¹¦Äܸü¶à£¬¸üÇ¿¡£¡£¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3   ......