|
|
8³â Àü
|
SELECT
SELECT * FROM Å×À̺í¸í WHERE Çʵå='Á¶°Ç' AND Çʵå2='Á¶°Ç2'
SELECT Çʵå1, Çʵå2, Çʵå3 FROM Å×À̺í¸í
SELECT * FROM TAB; Á¸ÀçÇÏ´Â ¸ðµç Å×ÀÌºí º¸±â
SELECT DISTINCT Çʵå1 FROM Å×À̺í¸í; Áߺ¹Á¦°ÅÇϱâ
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 BETWEEN 00 AND 00; //00ºÎÅÍ 00»çÀÌ¿¡¼
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 IN (00, 00); //00°ú 00Áß¿¡¼
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 LIKE '%´Ü¾î%';
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 IS NULL; or NoT IS NULL
UPDATE
UPDATE Å×À̺í¸í SET Çʵå='°ª', Çʵå2='°ª', Çʵå3='°ª' WHERE Çʵå LIKE 'Á¶°Ç'
INSERT
INSERT INTO Å×À̺í¸í(Çʵå1, Çʵå2) VALUES ('°ª', '°ª' );
ºñ±³¿¬»êÀÚ : >, >=, <, <=, =, <>(not equal)
DROP TABLE Å×À̺í¸í;
CREATE TABLE Å×À̺í¸í (
Çʵå¸í ŸÀÔ Á¶°Ç,
id varchar2(15) primary key,
pass varchar(15) not null,
no number(5)
)
½ÃÄö½º »ý¼º : CREATE SEQUENCE ½ÃÄö½ºÀ̸§
increment by 1
start with 1
nomaxvalue
nocycle
nocache;
¿Ü·¡Å° »ý¼º : ALTER TABLE Å×À̺í¸í ADD ( FOREIGN KEY (Çʵå) REFERENCES Å×À̺í¸í2);
Ä®·³ ¼öÁ¤ : ALTER TABLE Å×À̺í¸í MODIFY (Çʵå ŸÀÔ);
Ä÷³ Ãß°¡ : ALTER TABLE Å×À̺í¸í ADD ( ÇʵåÀ̸§ ÇʵåŸÀÔ );
Ä®·³ ¸®³×ÀÓ : ALTER TABLE Å×À̺í¸í RENAME COLUMN Ä÷³À̸§ TO »õÀ̸§;
Null°ª ó¸®Çϱâ : SELECT isNULL(Çʵå, '0') FROM Å×À̺í
¹æ±Ý ÀμƮÇÑ ÀÚµ¿Áõ°¡°ª ID °¡Á®¿À±â : SELECT @@IDENTITY (ÇöÀç ¼¼¼Ç¿¡¼¸¸ »ç¿ë°¡´É)
ÇöÀç Å×À̺íÀÇ °¡ÀåÅ« Å«Å«°ª °¡Á®¿À±â : SELECT IDENT_CURRENT('Å×À̺í¸í')
¼öÇàµÈ SQL¹®¿¡ ÀÇÇØ ¿µÇâ¹ÞÀº ÇàÀÇ ¼ö : SELECT @@ROWCOUNT
³¯Â¥ °è»êÇϱâ : SELECT * FROM Å×À̺í¸í WHERE DATEADD(DAY, CONVERT(INT, Ä÷³¸í), ³¯Â¥Ä÷³) > getdate()
Å×À̺í Á¤º¸º¸±â : EXEC sp_help Å×À̺í
Ä÷³ Á¤º¸º¸±â : EXEC sp_columns Å×À̺í
¾Ù¸®¾î½º »ç¿ë : SELECT Çʵå AS A FROM Å×À̺í (º°Äª¿¡ Ư¼ö¹®ÀÚ ÀÖÀ¸¸é [] »ç¿ë]
ÁÖ¼® : -- or /* */
º¯¼öÀÇ ¼±¾ð : DECLARE @º¯¼ö¸í ÀÚ·áÇü, @º¯¼ö¸í ÀÚ·áÇü
º¯¼ö ÇÒ´ç : SET @º¯¼ö¸í = °ª
º¯¼ö°ª °¡Á®¿À±â : SELECT @º¯¼ö¸í
ÀϺκи¸ °¡Á®¿À±â : SELETC TOP 5 Ä÷³ FROM Å×À̺í
¹üÀ§Á¤Çϱâ SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ BETWEEN 10 AND 20
SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ IN ('aaa', 'bbb', 'ccc')
ÆÐÅϸÅĪ : SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ LIKE '%Á¦¸ñ%"
_ : ¾î¶²°ÍÀ̵ç ÇÑ ¹®ÀÚ
% : ¾ø°Å³ª ¾Æ¹« ±ÛÀÚ¿À°Å³ª
[] : []¾È¿¡ ÀÖ´Â ±ÛÀÚµé - [b-f]
[^] : ^´Ù¸§¿¡ ÀÖ´Â ±ÛÀÚ¸¦ Á¦¿ÜÇÑ ´Ù¸¥ °Í
Áߺ¹Á¦°Å : SELECT DISTINCT Ä÷³ FROM Å×À̺í
GROUP BY : SELECT Ä÷³1, sum(Ä÷³2) FROM Å×À̺í WHERE Á¶°Ç GROUP BY Ä÷³1 HAVING sum(Ä÷³2) >= 30
(°è»êÇÔ¼ö°¡ ¹Ýµå½Ã ÀÖ¾î¾ß ÇÑ´Ù, GROUP BY ALLÀ» »ç¿ëÇϸé WHEREÁ¦¿ÜµÈ°Í µµ Æ÷ÇÔ)
À̳ÊÁ¶ÀÎ : SELECT Ä÷³ FROM Å×À̺í INNER JOIN Å×À̺í ON Ä÷³=Ä÷³
¾Æ¿ôÅÍÁ¶ÀÎ : SELECT Ä÷³ FROM Å×À̺í LEFT OUTER JOIN Å×À̺í ON Ä÷³=Ä÷³
(¾î´ÀÇÑÂÊÀÇ µ¥ÀÌÅ͸¦ ¸ðµÎ °¡Á®¿Â´Ù.)
IN : SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³2 IN ( SELECT Ä÷³2 FROM Å×À̺í )
(IN¾ÈÀÇ ÇÏÀ§ÁúÀÇ´Â DISTINCT°¡ ºÙÀº °ÍÀ¸·Î µ¿ÀÛ)
EXISTS : SELECT Ä÷³1 FROM Å×À̺í WHERE EXISTS ( SELECT * FROM Å×À̺í WHERE Á¶°Ç )
(EXISTS´Â ÇÏÀ§Äõ¸®°¡ ¾î¶² °á°ú¶óµµ µ¹·ÁÁö¸é Âü)
ÀÓ½ÃÅ×ÀÌºí ¸¸µé±â : SELECT INTO SELECT * INTO »õÅ×À̺í¸í FROM Å×À̺í (´Ù¸¥¼¼¼Ç¿¡¼µµ °¡´É, DROPÇØ¾ß »èÁ¦µÊ)
SELECT INTO SELECT * INTO #»õÅ×À̺í¸í FROM Å×À̺í (ÇØ´ç¼¼¼Ç¿¡¼¸¸ °¡´É, ¼¼¼Ç²÷¾îÁö¸é »èÁ¦µÊ)
SELECT INTO SELECT * INTO ##»õÅ×À̺í¸í FROM Å×À̺í (´Ù¸¥¼¼¼Ç¿¡¼µµ °¡´É, ¼¼¼Ç²÷¾îÁö¸é »èÁ¦µÊ)
UNION : SELECT Ä÷³1, Ä÷³2 FROM Å×À̺í
UNION
SELECT Ä÷³1, Ä÷³2 FROM Å×À̺í
(UNIONÀº Ä÷³ÀÇ ÀÚ·áÇü°ú ¼ø¼°¡ ¸Â¾Æ¾ß ÇÑ´Ù. Áߺ¹µ¥ÀÌÅÍ´Â Á¦°ÅµÇ¸ç UNION ALLÀ» Çϸé Áߺ¹µ¥ÀÌÅ͵µ °¡Á®¿Â´Ù.)
Ä÷³ Ãß°¡ : ALTER TABLE Å×À̺í¸í ADD »õÄ÷³ VARCHAR(10) NULL
Ä÷³ º¯°æ : ALTER TABLE Å×À̺í¸í ALTER COLUMN Ä÷³ VARCHAR(10) NULL
Ä÷³ »èÁ¦ : ALTER TABLE Å×ÀÌºíº´ DROP COLUMN Ä÷³
»èÁ¦ : DELETE FROM Å×À̺í¸í WHERE Á¶°Ç
¾÷µ¥ÀÌÆ® : UPDATE Å×À̺í SET Ä÷³ = °ª WHRER Á¶°Ç
Æ®·£Àè¼Ç : BEGIN TRAN
ROLLBACK
COMMIT
µ¡) SELECT¿¡ ¿Ø¸¸Çϸé * ´Â »ç¿ëÇÏÁö ¾Ê´Â´Ù.
µ¡) WHEREÀý¿¡¼ ¿¬»êÀÚÀÇ ¿ÞÂÊÀº °¡µ¿ÇÏÁö ¾Ê´Â´Ù. Ä÷³À» °¡°øÇÏ¸é »öÀÎÀ» »ç¿ëÇÒ ¼ö ¾ø´Ù.
WHERE Ä÷³ * 3 < 10 ¸»°í WHERE Ä÷³ < 10 / 3 À» »ç¿ëÇÏÀÚ |
|
̵̧ : 402 |
̵̧
¸ñ·Ï
|
|