4. ±âº» Å×À̺íÀÇ Á¦°Å
DROP TABLE ±âº»Å×À̺íÀ̸§ ;
5. À妽ºÀÇ Á¦°Å
DROP INDEX À妽ºÀ̸§ ;
1. µ¥ÀÌŸ °Ë»ö
SELECT [ALL | DISTINCT] ¿¸®½ºÆ®
FROM Å×À̺íÀ̸§ [¹üÀ§º¯¼ö] [{, Å×À̺íÀ̸§ [¹üÀ§º¯¼ö]}*]
[WHERE Á¶°Ç]
[GROUP BY ¿¸®½ºÆ®
[HAVING Á¶°Ç]]
[ORDER BY ¿¸®½ºÆ® [ASC | DESC]] ;
! ¿ ÀüºÎ¸¦ °Ë»ö : *
! DISTINCT : Áߺ¹Á¦°Å
! Á¶°Ç½Ä »ç¿ë ºñ±³¿¬»êÀÚ : = >, <, AND, OR, NOT
! ¹üÀ§º¯¼ö°¡ ¾øÀ¸¸é Å×À̺í À̸§À» ¹üÀ§ º¯¼ö·Î »ç¿ë
! GROUP BY : ¿À̸§º°·Î ºÐÇÒ (°¢ ±×·ì¿¡ ´ëÇØ SELECT¹®À» Àû¿ë)
! HAVING : GROUP¿¡ ´ëÇÑ Á¶°Ç ¸í¼¼.
¿¹ )
SELECT CNO, AVG(FINAL)
FROM ENROL
GROUP BY CNO
HAVING COUNT(*)> 3;
- Áý´ÜÇÔ¼ö¸¦ ÀÌ¿ëÇÑ °Ë»ö
SELLCT COUNT | SUM | AVG | MAX | MIN ([DISTINCT] ¿À̸§)
FROM .....
- SELFJOIN
¿¹)
SELECT S1.SNO, S2.SNO
FROM STUDENT S1, STUDENT S2
WHERE S1.DEPT = S2.DE¡¦(»ý·«)
2. µ¥ÀÌŸÀÇ °»½Å
3. µ¥ÀÌŸÀÇ »ðÀÔ
4. µ¥ÀÌŸÀÇ »èÁ¦
|
);
- UNION
¿¹)
SELECT SNO
FROM STUDENT
WHERE YEAR = 3
UNION
SELECT SNO
FROM ENROL
WHERE CNO=`C324`;
! Áߺ¹µÈ ÅõÇÃÀº Á¦°ÅµÊ
2. µ¥ÀÌŸÀÇ °»½Å
UPDATE Å×À̺íÀ̸§
SET ¿À̸§ = »ê¼ú½Ä {, ¿À̸§ = »ê¼ú½Ä}*
[WHERE Á¶°Ç];
3. µ¥ÀÌŸÀÇ »ðÀÔ
INSERT INTO Å×À̺í [(¿À̸§ {[, ¿À̸§]}*]
VALUES (¿°ª¸®½ºÆ®) | SELECT¹® ;
4. µ¥ÀÌŸÀÇ »èÁ¦
DELETE FROM Å×À̺íÀ̸§
[WHERE Á¶°Ç¹® ];
1. VIEWÀÇ »ý¼º
CREATE VIEW ºäÀ̸§ [(¿À̸§¸®½ºÆ®)]
AS SELECT¹®
[WITH CHECK OPTION];
! WITH CHECK OPTION : ÀÌ VIEWÀÇ °»½ÅÀ̳ª »ðÀÔ¿¬»êÀº VIEWÁ¤ÀÇ Á¶°ÇÀ» È®ÀÎ
! ALTER¹®ÀÇ »ç¿ëÇÒ ¼ö ¾ø´Ù.
¿¹)