¼ÙÉèÓÐÒ»¸ö±í
TabA£¨id int£©
ÀïÃæÊý¾ÝÈçÏ£º
id
0
1
2
3
4
5
6
7
7
8
9
10
11
12
12
13
...
Ôõô²éѯ³öidÖØ¸´µÄÊý¾Ý£¿£¿£¿
¼´£¬ÏëÒªµÄ½á¹ûΪ£º
id
7
12
˼·:
select * from tb where id in select count(id)>1
......
ÏîÄ¿ µØÖ· Ãæ»ý id
proj1 address 10 1
proj1 address 10 2
proj1 address &nbs ......
±í½á¹¹ÊÇÕâÑù
id name
1 asdf
2 asdf
3 asdf
4 asf
a asdf
5 asdf
6 asdf
ÏÖÔÚʵÏֵĽá¹ûÊDzéѯ 3 ~~ 6Ö®¼äµÄÊý¾Ý £¬£¬´ó¼Ò¿´5ÉÏÃæÊǸöaŶ£¬ÎÒÏÖÔÚÓà between ³ö´í ......
Ó¦¸ÃÔõôд£¿
±í id parentid
¸ù¾ÝÒ»¸öÖ¸¶¨µÄid£¬²é³öËüµÄËùÓи¸½Úµã£¬×游½Úµã£¬Ò»Ö±µ½¶¥£¬²»Óô洢¹ý³Ì
°ï°ï棬¼ÇµÃÒÔǰÀÏʦ½²sqlµÄʱºò д¹ý ¸øÍüÁË¡£¡£¡£¡£
mysql Öв»ÐУ¬ORACLEÖпÉÒÔ(connect to)£¬
´æ´¢¹ý³ÌÄã¿ÉÒԲο¼
MySQLÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ
http://blog.csdn.net ......
¸÷λÀÏ´ó¸øµã½¨Òé
ËäÈ»¶¼ÊǹØÏµÊý¾Ý¿âÖеÄٮٮÕߣ¬µ«¶þÕßÊÇÍêÈ«²»Í¬µÄ²úÆ·£¬Ã»ÓÐÏÈѧÄÄÒ»¸öµÄÇø·Ö£¬¹Ø¼üÊÇÊý¾Ý¿â»ù±¾¸ÅÄîºÍSQLÓï¾äµÄѧϰÉÏ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ£¿
Ëæ±ãÏÈѧÄÄÖÖ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ
лл´ó¼ÒÁË£¬Ò»¸öȺÀïµÄȺÓÑ˵ÎÒÖ±½Óѧoracle»áºÜÉËÐÄ£¬ËùÒÔÎÊÁË¡ ......
ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿ÓÐʲô½Ý¾¶Ã»ÓУ¿Çë¸ßÊÖÖ¸µãÃÔ½ò£¬ÔÚ´ËлÁË¡£
ºÇºÇ ûʲô½Ý¾¶ ƽʱ¶à¶à¿´Ê鲢ʵ¼ù°É
ÎÒÒ²ÏëÖªµÀ¡¡ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ
¶àдд°É¡£¶à¶¯¶¯ÄÔ¾
ÒýÓÃ
ÎÒÒ²ÏëÖªµÀ¡¡ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ
ºÇºÇ ¶àÅÜÅÜÓï¾ä°É¡£¡£¡£
×Ô¼º¶à¶¯ÊÖддÁË¡£¡£¡£
ÓÐÒ» ......