Effective SQL¤¤¤åª© | ¼g¥X¨}¦nSQLªº61Ó¨ãÅé°µªk ( ÁcÅé ¦r) |
§@ªÌ¡GJohn L. Viescasµ¥ | Ãþ§O¡G1. -> ¸ê®Æ®w -> SQL»y¨¥ |
ĶªÌ¡G·¨´L¤@ |
¥Xª©ªÀ¡GùÖ®p¥Xª© | 3dWoo®Ñ¸¹¡G 46904 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT©w»ù¡G 450 ¤¸ §é¦©»ù¡G 338 ¤¸
|
¥Xª©¤é¡G6/1/2017 |
¶¼Æ¡G |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ÁcÅé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9789864764358 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡G |
¤º®e²¤¶¡G½u¤W¤U¸ü¤º®e ¡§»P¨ä½M¦£©Î¥|³B´M§äµª®×¡A½ÐÀ°¦Û¤v¤@Ó¦£¡Gª½±µ¶R³o¥»®Ñ§a¡I¡¨-Dave Stokes¡AMySQLªÀ¸s¸g²z¡AOracle CorporationEffective SQL¾ã¦X¹ê°È¤è®×»P¬}¨£¡A¨ó§U§A¸Ñ¨M½ÆÂøªº°ÝÃD¡A¥H¤Î³]p¥X¯à²¤Æ¸ê®ÆºÞ²zªº¸ê®Æ®w¡C¥»®Ñµ²¦X³Ì¨Î¹ê½î¤èªk»P¹ê°È®×¨Ò¡A²[»\¦UºØSQLª©¥»¡GIBM DB2¡BMicrosoft Access¡BMicrosoft SQL Server¡BMySQL¡BOracle Database»PPostgreSQL¡C§@ªÌÉų¥@¬É¯Å¸ê®Æ®wÅU°Ý»PÁ¿®vªºÂ×´I¸gÅç¡AÂk¯Ç¤F¼g¥X¨}¦nSQLªº61Ó¨ãÅé°µªk¡A¨Ã´£¨Ñ¤£¦PSQLª©¥»¤¤ªº®t§O¡AµL½×§A¬O¨Ï¥Î¦óºØSQLª©¥»³£¯à±q¤¤Àò¯q¡C¥»®Ñ´£¨Ñ²M·¡¡B°È¹êªº¸ÑÄÀ¡A±M®aªºµ´©Û»P¤j¶q¹ê¥Îªºµ{¦¡½X¡C°£¤F»yªk¤§¥~¡A¤]°Q½×¸ê®Æ®w³]p³Ì¨Î¤Æ¡B¶¥¼hºÞ²z»P¤¸¸ê®Æµ¥¦UºØijÃD¡CY§A¹ïSQL¤w¸g¦³°ò¥»»{ÃÑ¡A³o¥»«ü«n±N¯àÀ°§U§A¦¨¬°¸Ñ¨MSQL°ÝÃDªº±M®a¡C?¥´³y§ó¦nªº¸ê®Æ¼Ò«¬¨Ã§ï¥¿¦³°ÝÃDªº¼Ò«¬?¹ê§@´£¤É¬d¸ß®Ä¯àªº¯Á¤Þ?³B²z§A¤£¯à±±¨îªº¥~³¡¸ê®Æ¨Ó·½?°ª®Ä²vªºÂ^¨ú¨Ã·J¾ã§A©Ò»Ýªº¸ê°T?¼¶¼g§ó¦³¼u©Êªº¤l¬d¸ß?¤ÀªR»PŪ¨ú¦UºØ¸ê®Æ®wªº¤¸¸ê®Æ?¨Ï¥Î²Ã¥d¨à¿n(Cartesian product)»P¹ïÀ³ªí®æ¡A¸Ñ¨M¶Ç²ÎJOINµLªk³B²zªº°ÝÃD?«Øºc¶¥¼h¸ê®Æ¼Ò«¬¡GºÞ²zSQLªº¨ú±Ë»P¯ÊÂI |
¥Ø¿ý¡G§Ç PÁ Ãö©ó§@ªÌ «e¨¥
²Ä 1 ³¹¡@¸ê®Æ¼Ò«¬³]p ²Ä 2 ³¹¡@µ{¦¡¤Æ»P¯Á¤Þ³]p ²Ä 3 ³¹¡@¤£¯à§ïÅܳ]p®É ²Ä 4 ³¹¡@¹LÂo»P·j´M¸ê®Æ ²Ä 5 ³¹¡@·J¾ã ²Ä 6 ³¹¡@¤l¬d¸ß ²Ä 7 ³¹¡@¨ú±o»P¤ÀªR¤¸¸ê®Æ ²Ä 8 ³¹¡@²Ã¥d¨à¿n ²Ä 9 ³¹¡@¹ïÀ³ªí ²Ä 10 ³¹¡@«Øºc¶¥¼h¸ê®Æ¼Ò«¬ ªþ¿ý¡@®É¶¡»P¤é´Á«¬§O¡B¾Þ§@¡A¥H¤Î¨ç¦¡ |
§Ç¡G |