bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL SELECT Keyword

Concept visual

SQL SELECT Keyword

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

SELECT Keyword

Previous

❮ SQL Keywords

Next

Select

The SELECT

command is used to select data from a database. The data returned is stored in a result table, called the result set. The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table:

Example

SELECT CustomerName, City FROM Customers;
The following SQL statement selects all the columns from the "Customers"

table:

Example

SELECT * FROM Customers;

Previous

❮ SQL Keywords

Next

Previous

SQL SELECT TOP, LIMIT and ROWNUM Keywords

Next

SQL SELECT DISTINCT Keyword