Learn SQL Database Programming

Syntax for selecting data

To select all columns from one table, you can use the following sample syntax:

SELECT * FROM tablename; 

To select one or more columns from one table, you can use the following sample syntax:

SELECT col1, col2, col3 FROM tablename; 

To select from a specified database, you can use the following sample syntax:

USE databasename;SELECT col1, col2, col3 FROM tablename; 

To select distinct records from a table, you can use the following sample syntax:

SELECT DISTINCT col1, col2 FROM tablename;

To limit and offset the number of records that are returned, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameLIMIT 500 OFFSET 1000; 

To comment on your SQL query, you can use the following sample syntax: ...