Other Functions

Question 1

AND / OR

Answer 1

SELECT column_name(s)
FROM table_name
WHERE condition
AND|OR condition

Question 2

ALTER TABLE

Answer 2

ALTER TABLE table_name
ADD column_name datatype
or
ALTER TABLE table_name
DROP COLUMN column_name

Question 3

AS (alias)

Answer 3

SELECT column_name AS column_alias
FROM table_name
or
SELECT column_name
FROM table_name AS table_alias

Question 4

Between

Answer 4

SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2

Question 5

CREATE index

Answer 5

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
...
)

Question 6

CREATE VIEW

Answer 6

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Question 7

DELETE

Answer 7

DELETE FROM table_name
WHERE some_column=some_value
or
DELETE FROM table_name
(Note:Deletes the entire table!!)
DELETE * FROM table_name
(Note:Deletes the entire table!!)

Question 8

DROP DATABASE

Answer 8

DROP DATABASE database_name

Question 9

EXISTS

Answer 9

IF EXISTS (SELECT * FROM table_name WHERE id = ?)
BEGIN
--do what needs to be done if exists
END
ELSE
BEGIN
--do what needs to be done if not
END

Question 10

GROUP BY

Answer 10

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

Question 11

HAVING

Answer 11

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value

Question 12

IN

Answer 12

SELECT column_name(s)
FROM table_name
WHERE column_name
IN (value1,value2,..)

Question 13

INSERT INTO

Answer 13

INSERT INTO table_name
VALUES (value1, value2, value3,....)
or
INSERT INTO table_name
(column1, column2, column3,...)
VALUES (value1, value2, value3,....)

Question 14

INNER JOIN

Answer 14

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.

Question 15

LEFT JOIN

Answer 15

SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.

Question 16

RIGHT JOIN

Answer 16

SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.

Question 17

FULL JOIN

Answer 17

SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON table_name1.column_name=table_name2.

Question 18

LIKE

Answer 18

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern

Question 19

SELECT

Answer 19

SELECT column_name(s)
FROM table_name
ORDER BY column_name [ASC|DESC]

Question 20

SELECT *

Answer 20

SELECT *

FROM table_name

Question 21

SELECT DISTINCT

Answer 21

SELECT DISTINCT column_name(s)

FROM table_name

Question 22

SELECT INTO

Answer 22

SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_table_name
or
SELECT column_name(s)
INTO new_table_name [IN externaldatabase]
FROM old_table_name

Question 23

SELECT TOP

Answer 23

SELECT TOP number|percent column_name(s)

FROM table_name

Question 24

TRUNCATE TABLE

Answer 24

TRUNCATE TABLE table_name

Question 25

UNION

Answer 25

``` SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2 ```

Question 26

UNION ALL

Answer 26

``` SELECT column_name(s) FROM table_name1 UNION ALL SELECT column_name(s) FROM table_name2 ```

Question 27

UPDATE

Answer 27

UPDATE table_name SET column1=value, column2=value,... WHERE some_column=some_value

Question 28

WHERE

Answer 28

SELECT column_name(s) FROM table_name WHERE column_name operator value