µ{¦¡½X¨ã¥iŪ©Ê«üµ{¦¡½X¼g±o¦³¦h²M·¡¡C¨ä¥\¯à´N¹³´¶³q§@¤åùØ¡A§A·|¤À¬q¡B¹j¦æ¡B¦³ª`¸Ñµ¥µ¥¤@¼Ë¡C
n¦³°ª¥iŪ©Êªºì¦]¦b©óµ{¦¡½X¹ê¹ê¦b¦b¬O¡u¤õ¬P¤å¡v¡G·í§A¬ÝµÛ´X¤d¦æ¬Æ¦Ü´X¸U¦æªºµ{¦¡½X®É¡A¤£½×§A¦³¦h±M·~¡A§A¤]«Ü®e©ö°g¥¢¦b¯í¯íªºµ{¦¡½X¤¤¡C¡]¤×¨ä¬O·íµ{¦¡½X¤£¬O§A¼gªº¡^¬G¦¹¡A¥iŪ©Êªº¼Ð·Ç´NÀ³¹B¦Ó¥Í¡A¼Ð·Ç³q±`¥]¬A
(1) µù¸Ñ (comment)¡Gcommentªº§@¥Î¦b©ó¸ÑÄÀ¤@¦æ/¬qµ{¦¡½X¡C¬O´¶³qªº¤å¦r»y¥y¡C
(2) ÁY¦æ (indentation)¡Gµ{¦¡½X³q±`¬O±_ª¬µ²ºc (nested structure)¡A¦³ÁY¦æ´N·|®e©öÂIÂç²M±_ª¬µ²ºc¡C
(3) ¹j¦æ¡Gµ{¦¡½X¦³¤£¦Pªº³¡¥÷¡A¥H¹j¦æ©Î¤À¹j½u¤À¶}¦U³¡¥÷¡C
(4) ¼g½X²ßºD¡G¤£¦Pªºµ{¦¡½X¦³¤£¦Pªº²ßºD¡A¦p¤@¶}©l´N«Å§i©Ò¦³ÅܼƵ¥¡Aµø¥G»y¨¥Ãþ§O¦Ó©w¡C
(5) ¤j²Ó·¢¡G¥H¤j²Ó·¢¤À§O¥X¤£¦PÃþ«¬ªº¦r¡A¦p keywords¡Avariablesµ¥
§C¥iŪ©Êªºµ{¦¡½X¡]¥H SQL ¬°¨Ò¡^
select name, dob, address, phoneh, phonem, email from personal where salary > (select average(salary) from personal) order by salary;
°ª¥iŪ©Êªºµ{¦¡½X
SELECT Name, Dob, Address, PhoneH, PhoneM, EMail
FROM Personal
WHERE Salary > (SELECT AVERAGE (Salary) FROM Persaonl)
ORDER BY Salary
¡]µù ³oºØÂ²³æªºSQL ³q±`¤£¥Îindentation¡^
¡i¥»¤H¥u¬O¶W¯Åªìô¡A¥u²¤ª¾¤@¤G¡K¡K¡K¸ÛÁܰª¤â©ò¥¿¡j
¹ê¥Î¬ÛÃö·j´M: av ati