dmccloskey
commented
5 years ago Overview of common SQL statements
SELECT
SELECT column1, column2 FROM table1, table2 WHERE [ conditions ] GROUP BY column1, column2 HAVING [ conditions ] ORDER BY column1, column2 LIMIT [no of rows] OFFSET [row num]
INSERT
INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN);
UPDATE
UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];
DELETE
DELETE FROM table_name WHERE [condition];
UNION keyword
SELECT column1 [, column2 ] FROM table1 [, table2 ] [WHERE condition]
UNION (ALL)
SELECT column1 [, column2 ] FROM table1 [, table2 ] [WHERE condition]
JOIN keyword
SELECT ... FROM table1 CROSS JOIN table2 ... SELECT table1.column1, table2.column2... FROM table1 INNER JOIN (LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN) table2 ON table1.common_filed = table2.common_field;
ALTER
ALTER TABLE table1 ADD (DROP) ALTER DIMENSION dimension1 ADD (DROP)
CREATE/DROP
CREATE TABLE CREATE DIMENSION
Description
As a user, I would like to be able to
select,insert into,delete,update,drop,create,join,aggregate, and perform other typical SQL-like or analytics methods (e.g., mean/count across a column). I would like to be able to perform these operations on either a single thread, threadpool, or Gpu.Objectives
Implement the following operations
Validation