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

°ï濴һϣ¬Ôõôдsql ÅÅÐò

ÅÅÐòǰ
5 245 405
5 245 406
5 239 396
5 239 395
5 240 398
5 240 397
5 241 399
5 241 400
5 242 401
5 242 402
ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239 395
5 239 396
5 240 397
5 240 397
5 241 398
5 241 400
5 242 401
5 242 402

ÏÈллÁË¡£


¸Ð¾õûʲô¹æÂɰ¡¡£¡£¡£¡£
     


order by ÁÐ2 ,ÁÐ3

ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239 395
5 239 396
5 240 397
5 240 398
5 241 399
5 241 400
5 242 401
5 242 402
¼±£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

5 245 405 ÕâÁ½¸öÊÇ235°É£¿
5 245 406
5 239 395
5 239 396
5 240 397
5 240 397
5 241 398
5 241 400
5 242 401
5 242 402

ÒýÓÃ
ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239395
5 239396
5 240397
5 240398
5 241 399
5 241 400
5 242 401
5 242 402
¼±£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

ÔÙ¼±Ò²²»ÐÐѽ£¬Äã×ܵÄ˵³öÀ´¹æÂɰÉ

²»ÊÇÁË£¬¾ÍÊÇ245£¬ËùÒÔ²ÅÕâô³î

......
select c1,c2,c3 from table
order by c1,c2,c3

ÎÒ¾ÍÊÇÏëÈÃ1¡¢2Áб£³Ö²»±ä£¬µÚ3ÁÐÉýÐòÅÅÁÐ

select c1,c2,c3 from table
group by c1,c2,c3
order by c3

ÒýÓÃ
ÎÒ¾ÍÊÇÏëÈÃ1¡¢2Áб£³Ö²»±ä£¬µÚ3ÁÐ


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ