Thu 23 Feb 2006
救命~~
Â
很牛的在写脚本,å¯æ˜¯ä¸‹é¢çš„结果,å´è®©æˆ‘想ä¸é€šã€‚。。。。。。。。。。。。。。。。
Â
Â
SQL> select id from profile where id not like ‘000%’;
no rows selected
SQL> select count(id) from profile where id like ‘000%’;
COUNT(ID)
——————
           121853
——————
           121853
SQL> select count(id) from profile id is not null;
COUNT(ID)
——————
           121854
——————
           121854
Â
æžæ‡‚了,咳咳
Leave a Reply
You must be logged in to post a comment.