ÇóSQLÓï¾ä
±íÈçÏ£º
ID ÉÌÆ·ID ÈÕÆÚ ÊµÔÚ¿â Èë¿â ³ö¿â
1 001 10/1 10 5
2 001 10/2 4 6
3 001 10/4 5 2
4 001 10/4 6
5 001 10/5 10
¡£¡£¡£¡£¡£¡£
ÏÖÔÚÏëµÃµ½ÒÔÏÂÐÅÏ¢
ÉÌÆ·ID ÈÕÆÚ ÊµÔÚ¿â µ÷ÕûÊý Èë¿â ³ö¿â
001 10/1 10 5
001 10/2 4 (5) 6
001 10/4 (4) 11
001 10/5 (4+5-2-6)
ʵÔÚ¿â¡¢Èë¿â¡¢³ö¿â¶¼Êǰ´ÕÕÉÌÆ·IDºÍÈÕÆÚ½øÐÐGroupÇóºÏ¼Æ£¬¹Ø¼üÊǵ÷ÕûÊýµÄ¼ÆËã
µ÷ÕûÊýµÄ¼ÆËã·½·¨ÊÇ¿´Õâ¸öÉÌÆ·µ±Ç°ÈÕÆÚ֮ǰÊÇ·ñÓÐʵÔڿ⣬
Èç¹ûûÓÐ ¾Í==µ±Ç°ÈÕÆÚ֮ǰµÄÈë¿â×ܺÍ-³ö¿â×ܺÍ
Èç¹ûÓÐ ¾Í=֮ǰµÄ¡¢À뵱ǰÈÕÆÚ×î½üµÄʵÔÚ¿â+ʵÔÚ¿âËùÔÚÈÕÆÚµ½µ±Ç°ÈÕÆÚÖ®¼äµÄ£¨Èë¿â×ܺÍ-³ö¿â×ܺͣ©
³õѧÕߣ¬Âé·³¸÷λǰ±²À²^^
ÅŰæ±äÂÒÁË£¬µ÷ÕûÏ¡£
½âÊÍÏ 4 + 5 -2 -6ÊÇÔõôÀ´µÄ
µÚ£¬2£¬3ÌõÊý¾ÝµÄÈë¿âÊÇnullѽ
²»ºÃÒâ˼°¡£¬ÖØÐ·¢Ò»Ï°¡
±íÈçÏ£º
ID ÉÌÆ·ID ÈÕÆÚ ÊµÔÚ¿â Èë¿â ³ö¿â
1 001 10/1 10 5
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ· ......
ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE
ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......