Introduction to Programming

SELECT-statement

The SELECT-statement has the following format:

SELECT column_name, column_name
FROM table_name WHERE some_column = some_value;

When all the columns have to be selected, it looks like this:

SELECT * FROM table_name WHERE some_column=some_value;

Here is a more general definition of WHERE-clause:

WHERE column_name operator value
Operator:
   =   Equal
   <>  Not equal. In some versions of SQL, !=
   >   Greater than
   <   Less than
   >=  Greater than or equal
   <=  Less than or equal
   IN  Specifies multiple possible values for a column   LIKE  Specifies the search pattern   BETWEEN  Specifies the inclusive range of vlaues in a column

The column_name operator value constructs can be combined using the AND and OR logical operator and grouped by brackets, ( ) ...