{"id":55730,"date":"2023-05-10T10:17:15","date_gmt":"2023-05-10T03:17:15","guid":{"rendered":"https:\/\/jobsgo.vn\/blog\/?p=55730"},"modified":"2025-02-14T09:00:17","modified_gmt":"2025-02-14T02:00:17","slug":"cac-cau-hoi-sql","status":"publish","type":"post","link":"https:\/\/jobsgo.vn\/blog\/cac-cau-hoi-sql\/","title":{"rendered":"Tuy\u1ec3n t\u1eadp c\u00e1c c\u00e2u h\u1ecfi SQL th\u01b0\u1eddng g\u1eb7p trong ph\u1ecfng v\u1ea5n"},"content":{"rendered":"\n
SQL th\u1ef1c ch\u1ea5t l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf trong h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u quan h\u1ec7. SQL kh\u00f4ng \u0111\u01a1n gi\u1ea3n, ph\u1ecfng v\u1ea5n SQL l\u1ea1i c\u00e0ng kh\u00f4ng d\u1ec5 d\u00e0ng. Nh\u01b0ng b\u1ea1n kh\u00f4ng c\u1ea7n qu\u00e1 lo l\u1eafng b\u1edfi n\u1eafm ch\u1eafc c\u00e1c c\u00e2u h\u1ecfi SQL<\/a> d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng v\u01b0\u1ee3t qua v\u00f2ng ph\u1ecfng v\u1ea5n v\u00e0 ghi \u0111i\u1ec3m v\u1edbi nh\u00e0 tuy\u1ec3n d\u1ee5ng.<\/p>\n M\u1ee5c l\u1ee5c<\/p> C\u00e1c k\u1ef9 n\u0103ng SQL \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi\u00a0<\/span>Business Analyst (BA)<\/span><\/strong>, gi\u00fap h\u1ecd khai th\u00e1c v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3. <\/span>Business Analyst l\u00e0 g\u00ec<\/a>?<\/span><\/strong>\u00a0<\/span>Business Analyst<\/span><\/strong>, hay c\u00f2n g\u1ecdi l\u00e0 chuy\u00ean vi\u00ean ph\u00e2n t\u00edch nghi\u1ec7p v\u1ee5, l\u00e0 ng\u01b0\u1eddi c\u00f3 vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c thu th\u1eadp, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, t\u1eeb \u0111\u00f3 \u0111\u01b0a ra c\u00e1c gi\u1ea3i ph\u00e1p \u0111\u1ec3 c\u1ea3i thi\u1ec7n quy tr\u00ecnh kinh doanh v\u00e0 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau c\u1ee7a t\u1ed5 ch\u1ee9c.<\/span><\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n SQL<\/a> (Structured Query Language) l\u00e0 m\u1ed9t lo\u1ea1i ng\u00f4n ng\u1eef \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong l\u1eadp tr\u00ecnh. Trong khoa h\u1ecdc m\u00e1y t\u00ednh, SQL th\u01b0\u1eddng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u trong h\u1ec7 th\u1ed1ng RDBMS ho\u1eb7c x\u1eed l\u00fd lu\u1ed3ng d\u1eef li\u1ec7u RDSMS. X\u00e9t v\u1ec1 b\u1ea3n ch\u1ea5t, SQL kh\u00f4ng ph\u1ea3i ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh nh\u01b0ng b\u1ea3n ti\u00eau chu\u1ea9n c\u1ee7a n\u00f3 l\u1ea1i c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng th\u00e0nh ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh.<\/p><\/blockquote>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n SQL c\u00f3 r\u1ea5t nhi\u1ec1u vai tr\u00f2 h\u1eefu \u00edch, n\u1ed5i b\u1eadt trong \u0111\u00f3 ph\u1ea3i k\u1ec3 \u0111\u1ebfn:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n MySQL l\u00e0 kh\u00e1i ni\u1ec7m c\u00f3 m\u1ed1i quan h\u1ec7 m\u1eadt thi\u1ebft \u0111\u1ed1i v\u1edbi ng\u00f4n ng\u1eef truy v\u1ea5n SQL. Theo \u0111\u00f3, n\u1ebfu SQL l\u00e0 m\u1ed9t d\u1ea1ng ng\u00f4n ng\u1eef truy v\u1ea5n th\u00ec MySQL l\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 s\u1eed d\u1ee5ng ch\u00ednh SQL l\u00e0m ng\u00f4n ng\u1eef d\u1eef li\u1ec7u ti\u00eau chu\u1ea9n.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n Khi s\u1eed d\u1ee5ng truy v\u1ea5n SQL v\u00e0 mu\u1ed1n hi\u1ec3n th\u1ecb chi ti\u1ebft th\u1eddi gian, ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n \u0111\u1ed1i v\u1edbi l\u1ec7nh GetDate.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n SQL c\u00f3 t\u01b0\u01a1ng \u0111\u1ed1i nhi\u1ec1u t\u1eadp con, trong \u0111\u00f3 c\u00f3 3 t\u1eadp \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t bao g\u1ed3m:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n SQL Injection l\u00e0 thu\u1eadt ng\u1eef ch\u1ec9 k\u1ef9 thu\u1eadt ch\u00e8n th\u00eam SQL v\u1edbi m\u1ee5c \u0111\u00edch thay \u0111\u1ed5i c\u00e2u truy v\u1ea5n ban \u0111\u1ea7u \u0111\u1ed3ng th\u1eddi t\u1ea1o l\u1ed7 h\u1ed5ng d\u1eef li\u1ec7u \u0111\u1ec3 khai th\u00e1c Database. Theo \u0111\u00e1nh gi\u00e1, SQL Injection l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 thu\u1eadt hack web \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t hi\u1ec7n nay.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n PRIMARY KEY hay c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn v\u1edbi t\u00ean g\u1ecdi kh\u00f3a ch\u00ednh l\u00e0 c\u1ed9t ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh duy nh\u1ea5t c\u1ee7a m\u1ed7i h\u00e0ng trong c\u00f9ng m\u1ed9t b\u1ea3ng. Gi\u00e1 tr\u1ecb c\u1ee7a PRIMARY KEY ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng duy nh\u1ea5t m\u1ed9t l\u1ea7n, tuy\u1ec7t \u0111\u1ed1i kh\u00f4ng c\u00f3 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng l\u1ea1i. Trong \u1ee9ng d\u1ee5ng v\u00e0 tri\u1ec3n khai kh\u00f3a ch\u00ednh, c\u1ed9t PRIMARY KEY kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p c\u00f3 gi\u00e1 tr\u1ecb NULL.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n FOREIGN KEY (Kh\u00f3a ngo\u1ea1i) l\u00e0 m\u1ed9t tr\u01b0\u1eddng kh\u00f3a ch\u00ednh thu\u1ed9c m\u1ed9t b\u1ea3ng b\u1ea5t k\u1ef3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o nh\u00f3m b\u1ea3ng c\u00f3 li\u00ean quan \u0111\u1ec3 t\u1ea1o ra tr\u01b0\u1eddng ph\u1ed5 bi\u1ebfn c\u00f3 li\u00ean quan m\u1eadt thi\u1ebft t\u1edbi hai b\u1ea3ng. C\u00e1c r\u00e0ng bu\u1ed9c kh\u00f3a trong FOREIGN KEY gi\u1eef nhi\u1ec7m v\u1ee5 th\u1ef1c thi to\u00e0n v\u1eb9n h\u1ec7 tham chi\u1ebfu.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n CHECK Constraint l\u00e0 m\u1ed9t r\u00e0ng bu\u1ed9c CHECK \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong vi\u1ec7c gi\u1edbi h\u1ea1n to\u00e0n b\u1ed9 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c lo\u1ea1i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u00f3 kh\u1ea3 n\u0103ng l\u01b0u tr\u1eef trong c\u00f9ng m\u1ed9t c\u1ed9t. N\u1ebfu b\u1ea3n ghi kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u1ee7a CHECK Constraint th\u00ec ch\u1eafc ch\u1eafn kh\u00f4ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef v\u00e0o trong b\u1ea3ng.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n Trigger l\u00e0 m\u1ed9t th\u1ee7 t\u1ee5c \u0111\u01b0\u1ee3c th\u1ef1c thi tr\u1ef1c ti\u1ebfp t\u1eeb ph\u00eda m\u00e1y ch\u1ee7 c\u01a1 s\u1edf d\u1eef li\u1ec7u khi c\u00f3 thao t\u00e1c ch\u00e8n, c\u1eadp nh\u1eadt, x\u00f3a l\u1ec7nh th\u1ef1c hi\u1ec7n v\u1edbi m\u1ed9t b\u1ea3ng c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c tri\u1ec3n khai tr\u00ean m\u00e1y t\u00ednh.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n SQL Comments l\u00e0 c\u00e2u truy v\u1ea5n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi ch\u1ee7 th\u1ec3 mu\u1ed1n \u0111\u01b0a th\u00eam ch\u00fa th\u00edch v\u00e0o truy v\u1ea5n SQL g\u1ed1c nh\u1eb1m b\u1ed5 sung ng\u1eef ngh\u0129a ho\u1eb7c gi\u1ea3i th\u00edch chi ti\u1ebft r\u00f5 r\u00e0ng h\u01a1n. D\u1ea5u hi\u1ec7u nh\u1eadn bi\u1ebft ph\u1ed5 bi\u1ebfn c\u1ee7a SQL l\u00e0 \u0111\u1eb7t gi\u1eefa hai n\u1ed1i li\u00ean ti\u1ebfp (-) ho\u1eb7c \/*…*\/. Sau khi \u00e1p d\u1ee5ng SQL Comments, tr\u00ecnh bi\u00ean d\u1ecbch s\u1ebd t\u1ef1 \u0111\u1ed9ng b\u1ecf qua nh\u1eefng d\u00f2ng c\u00f3 b\u00ecnh lu\u1eadn n\u00ean kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c thao t\u00e1c ti\u1ebfp theo.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n Index (Ch\u1ec9 m\u1ee5c) l\u00e0 thu\u1eadt ng\u1eef ch\u1ec9 b\u1ea3ng tra c\u1ee9u \u0111\u1eb7c bi\u1ec7t gi\u00fap Database Search Engine s\u1eed d\u1ee5ng gi\u1ea3m th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u su\u1ea5t th\u1ef1c hi\u1ec7n c\u00e1c truy v\u1ea5n l\u1eadp tr\u00ecnh. Index \u0111\u01b0\u1ee3c t\u1ea1o ra theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau, nh\u01b0ng ch\u1ee7 y\u1ebfu l\u00e0 tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t c\u1ee7a c\u00f9ng m\u1ed9t b\u1ea3ng.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n Subquery \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn v\u1edbi nhi\u1ec1u t\u00ean g\u1ecdi kh\u00e1c nhau nh\u01b0 truy v\u1ea5n con, truy v\u1ea5n ph\u1ee5 hay truy v\u1ea5n l\u1ed3ng nhau. \u0110\u00e2y th\u1ef1c ch\u1ea5t l\u00e0 m\u1ed9t truy v\u1ea5n b\u00ean trong truy v\u1ea5n g\u1ed1c SQL v\u00e0 \u0111\u01b0\u1ee3c nh\u00fang b\u1edfi m\u1ec7nh \u0111\u1ec1 WHERE.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n T\u1ed1i \u01b0u h\u00f3a truy v\u1ea5n l\u00e0 quy tr\u00ecnh ph\u1ee9c t\u1ea1p \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u nh\u1eb1m so s\u00e1nh c\u00e1c chi\u1ebfn l\u01b0\u1ee3c truy v\u1ea5n v\u00e0 t\u1ed1i \u01b0u h\u00f3a chi ph\u00ed tr\u00ean th\u1ef1c t\u1ebf.<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n View l\u00e0 m\u1ed9t b\u1ea3ng \u1ea3o ch\u1ee9a d\u1eef li\u1ec7u t\u1eeb m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng v\u1edbi l\u01b0\u1ee3t xem h\u1ea1n ch\u1ebf quy\u1ec1n truy c\u1eadp d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch kh\u00f3a c\u00e1c truy v\u1ea5n ph\u1ee9c t\u1ea1p. Ch\u1ebf \u0111\u1ed9 View th\u1ef1c ch\u1ea5t kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u nh\u01b0ng n\u00f3 gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng d\u1ec5 d\u00e0ng truy v\u1ea5n k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm, h\u1ea1n ch\u1ebf quy\u1ec1n truy c\u1eadp, thi\u1ebft l\u1eadp quy\u1ec1n ri\u00eang t\u01b0,…<\/p>\n G\u1ee3i \u00fd tr\u1ea3 l\u1eddi:<\/p>\n CTE l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a “Common Table Expression” (Bi\u1ec3u th\u1ee9c b\u1ea3ng chung). CTE l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong SQL cho ph\u00e9p b\u1ea1n t\u1ea1o ra t\u00ean b\u1ea3ng t\u1ea1m th\u1eddi v\u00e0 s\u1eed d\u1ee5ng n\u00f3 trong c\u00e2u truy v\u1ea5n.<\/p>\n CTE th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u00e1c b\u1ea3ng t\u1ea1m th\u1eddi trong c\u00e2u truy v\u1ea5n, gi\u00fap b\u1ea1n c\u1ea3i thi\u1ec7n kh\u1ea3 n\u0103ng \u0111\u1ecdc v\u00e0 qu\u1ea3n l\u00fd m\u00e3 SQL. N\u00f3 cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh m\u1ed9t bi\u1ec3u th\u1ee9c truy v\u1ea5n (subquery) v\u00e0 g\u00e1n cho n\u00f3 m\u1ed9t t\u00ean, sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean \u0111\u00f3 nh\u01b0 m\u1ed9t b\u1ea3ng \u1ea3o \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c c\u00e2u truy v\u1ea5n ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n B\u00e0i vi\u1ebft c\u1eadp nh\u1eadt th\u00f4ng tin gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c c\u00e2u h\u1ecfi SQL ph\u1ed5 bi\u1ebfn \u0111\u1ec3 d\u1ec5 d\u00e0ng v\u01b0\u1ee3t qua v\u00f2ng ph\u1ecfng v\u1ea5n. \u0110\u1eebng qu\u00ean chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a JobsGO<\/a> \u0111\u1ec3 nh\u1eefng ng\u01b0\u1eddi y\u00eau th\u00edch c\u00f4ng vi\u1ec7c n\u00e0y c\u00f9ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u01b0\u1edbc m\u01a1.<\/p>\n","protected":false},"excerpt":{"rendered":" \u0110\u00e1nh gi\u00e1 post SQL th\u1ef1c ch\u1ea5t l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf trong h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u quan h\u1ec7. SQL kh\u00f4ng \u0111\u01a1n gi\u1ea3n, ph\u1ecfng v\u1ea5n SQL l\u1ea1i c\u00e0ng kh\u00f4ng d\u1ec5 d\u00e0ng. Nh\u01b0ng b\u1ea1n kh\u00f4ng c\u1ea7n qu\u00e1…<\/p>\n","protected":false},"author":39,"featured_media":55731,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"","_yoast_wpseo_title":"Tuy\u1ec3n t\u1eadp c\u00e1c c\u00e2u h\u1ecfi SQL th\u01b0\u1eddng g\u1eb7p trong ph\u1ecfng v\u1ea5n - JobsGO Blog","_yoast_wpseo_metadesc":"B\u1ea1n chu\u1ea9n b\u1ecb tham gia ph\u1ecfng v\u1ea5n SQL, ch\u1eafc ch\u1eafn kh\u00f4ng th\u1ec3 b\u1ecf qua tuy\u1ec3n t\u1eadp c\u00e1c c\u00e2u h\u1ecfi SQL th\u01b0\u1eddng g\u1eb7p sau \u0111\u00e2y. Click t\u00ecm hi\u1ec3u ngay...","_yoast_wpseo_focus_keyphrase":"","faq":"","nganh_nghe_chuc_vu_lien_quan":["Th\u1ef1c T\u1eadp C\u00f4ng Ngh\u1ec7 Th\u00f4ng Tin"]},"categories":[7],"tags":[],"yoast_head":"\n1. C\u00e2u h\u1ecfi ph\u1ecfng v\u1ea5n SQL l\u00e0 g\u00ec?<\/span><\/h2>\n
\n
<\/a><\/dt>\n
2. N\u00eau c\u00e1c vai tr\u00f2 n\u1ed5i b\u1eadt c\u1ee7a SQL<\/span><\/h2>\n
\n
3. MySQL l\u00e0 g\u00ec?<\/span><\/h2>\n
4. N\u00eau c\u00e1ch hi\u1ec3n th\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i v\u1edbi c\u00e1c truy v\u1ea5n SQL<\/span><\/h2>\n
5. SQL c\u00f3 nh\u1eefng t\u1eadp con n\u00e0o?<\/span><\/h2>\n
\n
\n
<\/a><\/dt>\n
6. L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa m\u1ec7nh \u0111\u1ec1 HAVING v\u00e0 m\u1ec7nh \u0111\u1ec1 WHERE?<\/span><\/h2>\n
\n
7. S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa UNION v\u00e0 UNION ALL l\u00e0 g\u00ec?<\/span><\/h2>\n
\n
8. C\u00e2u h\u1ecfi ph\u1ecfng v\u1ea5n SQL Injection l\u00e0 g\u00ec?<\/span><\/h2>\n
9. PRIMARY KEY l\u00e0 g\u00ec?<\/span><\/h2>\n
10. FOREIGN KEY l\u00e0 g\u00ec?<\/span><\/h2>\n
\n
<\/a><\/dt>\n
11. CHECK Constraint l\u00e0 g\u00ec?<\/span><\/h2>\n
12. Trigger l\u00e0 g\u00ec?<\/span><\/h2>\n
13. DML v\u00e0 DDL l\u00e0 g\u00ec?<\/span><\/h2>\n
\n
14. C\u00e2u h\u1ecfi ph\u1ecfng v\u1ea5n SQL Comments l\u00e0 g\u00ec?<\/span><\/h2>\n
15. N\u00eau s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c l\u1ec7nh TRUNCATE, DELETE v\u00e0 DROP<\/span><\/h2>\n
\n
16. Index l\u00e0 g\u00ec?<\/span><\/h2>\n
17. C\u00e2u h\u1ecfi ph\u1ecfng v\u1ea5n SQL: Subquery l\u00e0 g\u00ec?<\/span><\/h2>\n
18. T\u1ed1i \u01b0u h\u00f3a truy v\u1ea5n l\u00e0 g\u00ec?<\/span><\/h2>\n
\n
<\/a><\/dt>\n
19. View l\u00e0 g\u00ec? N\u00eau l\u1ee3i \u00edch n\u1ed5i b\u1eadt c\u1ee7a View<\/span><\/h2>\n
20. C\u00e2u h\u1ecfi ph\u1ecfng v\u1ea5n SQL: CTE l\u00e0 g\u00ec?<\/span><\/h2>\n