Simple Queries

Query Conditions

The SELECT statement performs queries on a relational database and is the most common used SQL command. The result is stored in a result table.

Extract All Tuples

Extract all data in the table which includes all rows and columns.

SELECT * FROM table-name;

SELECT attr1, attr2, ..., attrN FROM table-name;

Extract a subset of tuples from the table where each tuple includes all of the attributes.

SELECT * FROM table-name WHERE condition;

SELECT attr1, attr2, ..., attrN FROM table-name WHERE condition;

SELECT * FROM table-name WHERE condition ORDER BY attr-list;

Query Conditions