SQL - Syntax pt.2

Question 1

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name;

Answer 1

SQL SELECT Statement

SELECT column1, column2….columnN FROM table_name;

Question 2

Various Syntax in SQL

SELECT DISTINCT column1, column2….columnN
FROM table_name;

Answer 2

SQL DISTINCT Clause

SELECT DISTINCT column1, column2….columnN
FROM table_name;

Question 3

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE CONDITION;

Answer 3

SQL WHERE Clause

SELECT column1, column2….columnN
FROM table_name
WHERE CONDITION;

Question 4

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE CONDITION-1 {AND|OR} CONDITION-2;

Answer 4

SQL AND/OR Clause

WHERE CONDITION-1 {AND|OR} CONDITION-2;

Question 5

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE column_name IN (val-1, val-2,…val-N);

Answer 5

SQL IN Clause

WHERE column_name IN (val-1, val-2,…val-N);

Question 6

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE column_name BETWEEN val-1 AND val-2;

Answer 6

SQL BETWEEN Clause

WHERE column_name BETWEEN val-1 AND val-2;

Question 7

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE column_name LIKE { PATTERN };

Answer 7

SQL LIKE Clause

WHERE column_name LIKE { PATTERN };

Question 8

Various Syntax in SQL

SELECT column1, column2….columnN
FROM table_name
WHERE CONDITION
ORDER BY column_name {ASC|DESC};

Answer 8

SQL ORDER BY Clause

ORDER BY column_name {ASC|DESC};

Question 9

Various Syntax in SQL

SELECT SUM(column_name)
FROM table_name
WHERE CONDITION
GROUP BY column_name;

Answer 9

SQL GROUP BY Clause

GROUP BY column_name;

Question 10

Various Syntax in SQL

SELECT COUNT(column_name)
FROM table_name
WHERE CONDITION;

Answer 10

SQL COUNT Clause

SELECT COUNT(column_name)
FROM table_name
WHERE CONDITION;

Question 11

Various Syntax in SQL

SELECT SUM(column_name)
FROM table_name
WHERE CONDITION
GROUP BY column_name
HAVING (arithematic function condition);

Answer 11

SQL HAVING Clause

HAVING (arithematic function condition);

Question 12

Various Syntax in SQL

CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
…..
columnN datatype,
PRIMARY KEY( one or more columns )
);

Answer 12

SQL CREATE TABLE Statement

CREATE TABLE table_name(
column1 datatype,

Question 13

Various Syntax in SQL

DROP TABLE table_name;

Answer 13

SQL DROP TABLE Statement

DROP TABLE table_name;

Question 14

Various Syntax in SQL

CREATE UNIQUE INDEX index_name
ON table_name ( column1, column2,…columnN);

Answer 14

SQL CREATE INDEX Statement

CREATE UNIQUE INDEX index_name
ON table_name ( column1, column2,…)

Question 15

Various Syntax in SQL

ALTER TABLE table_name
DROP INDEX index_name;

Answer 15

SQL DROP INDEX Statement

ALTER TABLE table_name
DROP INDEX index_name;

Question 16

Various Syntax in SQL

DESC table_name;

Answer 16

SQL DESC Statement

DESC table_name;

Question 17

Various Syntax in SQL

TRUNCATE TABLE table_name;

Answer 17

SQL TRUNCATE TABLE Statement

TRUNCATE TABLE table_name;

Question 18

Various Syntax in SQL

ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};

Answer 18

SQL ALTER TABLE Statement

ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};

Question 19

Various Syntax in SQL

ALTER TABLE table_name RENAME TO new_table_name;

Answer 19

SQL ALTER TABLE Statement (Rename)

ALTER TABLE table_name RENAME TO new_table_name;

Question 20

Various Syntax in SQL

INSERT INTO table_name( column1, column2….columnN)
VALUES ( value1, value2….valueN);

Answer 20

SQL INSERT INTO Statement

INSERT INTO table_name()
VALUES ();

Question 21

Various Syntax in SQL

UPDATE table_name
SET column1 = value1, column2 = value2….columnN=valueN
[ WHERE CONDITION ];

Answer 21

SQL UPDATE Statement

UPDATE table_name
SET column1 = value1
[ WHERE CONDITION ];

Question 22

Various Syntax in SQL

DELETE FROM table_name
WHERE {CONDITION};

Answer 22

SQL DELETE Statement

DELETE FROM table_name
WHERE {CONDITION};

Question 23

Various Syntax in SQL

CREATE DATABASE database_name;

Answer 23

SQL CREATE DATABASE Statement

CREATE DATABASE database_name;

Question 24

Various Syntax in SQL

DROP DATABASE database_name;

Answer 24

SQL DROP DATABASE Statement

DROP DATABASE database_name;

Question 25

Various Syntax in SQL

USE database_name;

Answer 25

SQL USE Statement

USE database_name;

Question 26

Various Syntax in SQL

COMMIT;

Answer 26

SQL COMMIT Statement

Question 27

Various Syntax in SQL

ROLLBACK;

Answer 27

SQL ROLLBACK Statement