SQL SELECT
The SELECT statement is used to select data from a database.
The result is stored in a result table, called the result-set.
To select only some columns you want you can use the following syntax:
SELECT column_name,column_name
FROM table_name;
FROM table_name;
By using the following syntax you select all columns of a table:
SELECT * FROM table_name;
If you want to select only some records who fulfill a specific criterion, you can use the where clause:
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
FROM table_name
WHERE column_name operator value;
Comments
Post a Comment