SQL ѧϰ±Ê¼Ç ¶à¹Ø¼ü×ÖÅÅÐò
ÈçºÎʵÏÖ¶à¸ö¹Ø¼ü×Ö°´ÕÕ²»Í¬ÅÅÐò¹æÔò½øÐÐÅÅÐòÄØ£¿
ORDER BY×Ó¾äÈÃÊý¾Ý¿â¶Ô²éѯ½á¹ûÅÅÐò£¬ORDER BY×Ӿ䱨Ðë·ÅÔÚ²éѯÓï¾äµÄ½áβ¡£Æä»ù±¾ÓÃ
·¨ÈçÏ£º
SELECT * from Contacts ORDER BY first_name;
Äã¿ÉÒÔ¶Ô¶àÁÐÊý¾ÝÅÅÐò¡£ÓÅÏÈ˳Ðò°´´Ó×óµ½ÓÒÒÀ´Î½µµÍ£¬ËùÒÔ²éѯÓï¾äÖи÷ÁеÄÅÅÁÐ˳ÐòºÜÖØÒª¡£
SELECT * from Contacts ORDER BY company, last_name, first_name;
²éѯ½á¹ûĬÈϰ´Êý×Ö»òÕß×ÖĸµÄÉýÐòÅÅÐò¡£Äã¿ÉÒÔÔÚORDER BY ×Ó¾äºóÃæ¼ÓÉÏDESC¹Ø¼ü´Ê¸Ä³É½µÐòÅÅÁС£ÔÚÏÂÃæµÄÀý×ÓÖУ¬×î¸ßµÄ
net_amountÅÅÔÚ×îÏÈ£¨½µÐò£©¡£¼ÙÈçÁ½ÐлòÕßÁ½ÐÐÒÔÉÏÊý¾Ý¶¼°üº¬ÁËͬÑùµÄnet_amountÖµ£¬ÄÇôͬÐÐÖÐlast_nameÖµÔÚ×Öĸ±íÖÐ×îÏÈ
³öÏÖµÄÅÅÏÈ£¬ÒòΪlast_nameÒ»Áл¹Êǰ´ÕÕÉýÐòÅÅÐòµÄ¡£
SELECT * from Sales ORDER BY net_amount DESC, last_name, first_name;
ÔÚ°´ÕÕ¶¨ÒåµÄÁÐÃûÅÅÐòÒԺ󣬴ó¶àÊýÊý¾Ý¿âËæºó½«°´ÕÕÊý¾Ý±íÄڵĵÚÒ»ÁÐÅÅÐòÈ»ºó˳ÐòÏòÓÒÔÙÅÅÐò¡£¾ßÌåµÄʵÏÖ¸÷Óб仯£¬Òò´Ë£¬Èç¹ûÅÅÐòÔÚÓ¦ÓÃÖбȽÏÖØ
ÒªÄÇôÄãÓ¦¸ÃÃ÷È·µØ¶¨ÒåËùÒªÅÅÐòµÄÁС£
ÁíÍâÒ»ÖµµÃ×¢ÒâµÄÎÊÌâÊÇ£¬²ÉÓÃORDER BY×Ӿ䣨ÒÔ¼°WHERE×Ӿ䣩£¬ÄãÕýÔÚÓÃÀ´ÅÅÐò½á¹ûµÄÊý¾ÝÁв¢²»Ò»¶¨µÃÊÇ·µ»Ø½á¹û¼¯ºÏµÄÒ»²¿·Ö¡£Ö»Òª
ËùÓÐÒýÓõÄÁж¼ÔÚÊý¾Ý±íÄÚ´æÔÚÔòÏÂÀýÍêÈ«ÓÐЧ£º
SELECT company, first_name, net_amount from Sales ORDER BY start_date, last_name
Ïà¹ØÎĵµ£º
1¡¢´´½¨°²×°ÏîÄ¿“Setup1”°²×°ÏîÄ¿
ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£
ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñÖеē°²×°ÏîÄ¿”¡£ÔÚ&ldquo ......
½«ÁÐת»»ÎªÐУ¬Ï൱ÓÚ½«±í½á¹¹Ðýת90¶È
T_Student ±í
Stud_ID
Sex
Name
1
ÄÐ
Tom
2
Å®
Anne
3
ÄÐ
Jack
Ö´ÐÐ: Exec proColumnToRow ’T_Student’,’Name’,’ New_ID’
ת»»ºóµÄ±í
New_ID
Tom
Anne
Jack
Stud_ID
1
2
3
Sex
ÄÐ
Å®
ÄÐ
& ......
±¾ÎÄ´ÓÊý¾Ý¿âÉè¼Æ¡¢¿ª·¢¡¢DBA¹ÜÀíµÈËĸö·½ÃæÐðÊöÁËSQL2005ÓëSQL2000Á½¸ö°æ±¾¼äµÄ¸Ä½ø¡£
¡¡¡¡Ò»¡¢Êý¾Ý¿âÉè¼Æ·½Ãæ
¡¡
¡¡1¡¢×Ö¶ÎÀàÐÍ¡£
¡¡¡¡varchar(max)
varchar(max)ÀàÐ͵ÄÒýÈë´ó´óµÄÌá¸ßÁ˱à³ÌµÄЧÂÊ£¬¿ÉÒÔʹÓÃ×Ö·û´®º¯Êý¶ÔCLOBÀàÐͽøÐвÙ×÷£¬ÕâÊÇÒ»¸öÁÁµã¡£µ«ÊÇÕâ¾ÍÒý·¢Á˶Ôvarchar
ºÍcharЧÂÊÌÖÂÛµÄÀÏÎÊÌâ¡£µ½µ ......
ÏÂÃæÌá³öÁË10ÌõºÍDB2 SQLÐÔÄÜÏà¹ØµÄ10ÌõÒòËØ£º
1¡¢ÌṩÊʵ±µÄͳ¼ÆÐÅÏ¢
¶ÔDB2ÓÅ»¯¹ÜÀíÆ÷£¨otimizer£©¶øÑÔ£¬ÈçºÎ¸ü¼ÓÓÐЧµÄÖ´ÐÐSQLÓï¾äÊÇÓÉ´æÔÚÓÚDB2 catalogÖеÄͳ¼ÆÐÅÏ¢¾ö¶¨µÄ£¬ÓÅ»¯Æ÷ÀûÓÃÕâЩÐÅÏ¢¾ö¶¨×îÓÅ»¯µÄ·¾¶¡£
Òò´Ë£¬ÎªÁ˱£³ÖϵͳÄܹ»×ö³ö×î¼ÑÑ¡Ôñ£¬ÐèÒª¾³£µÄÔËÐÐRunstatsÃüÁÀ´±£³Öϵͳͳ¼ÆÐÅÏ¢µÄ¼°Ê±ÓÐЧ¡£ ......
×ÔÁ¬½ÓÊÇÖ¸Ò»¸ö±íÓëÆä×ÔÉí½øÐÐÁ¬½Ó¡£
¾ÙÒ»¸ö¼òµ¥µÄʵÀý£¬Ò»¸öѧÉú¿Î³Ì³É¼¨±íStudentScore£¬ÆäÖаüÀ¨Ñ§Éú±àºÅ/studentid£¬ËùÑ¡¿Î³Ì/coursename,¿Î³Ì³É¼¨/score
Ñ¡ÔñÿÃſγ̵ÄǰÁ½ÃûѧÉú,²¢½«ËûÐÅÏ¢Êä³ö³öÀ´
´ËʱÄãµÄµÚÒ»·´Ó¦¾ÍÊÇÒª°ÑѧÉú°´ËùÑ¡¿Î³Ì½øÐзÖ×飬Ȼºó±È½Ï»ñµÃÿÃſγÌÀïÃæÇ°Á½Î»µÄѧÉú
·Ö×éµÄ·½Ê½ÓÐgroup b ......