Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Select
28/05/2024SQL Tutor: The SELECT statement
The SELECT statement
The SELECT statement is used to select the data from a table or a group of tables.
SELECT syntax
You can select some data fields from the table.
SELECT columnname1, columnname2 FROM table_name;
You can select all the fields available in the table, in this case use "*".
SELECT * FROM table_name;
SELECT statement examples
The below SELECT statement displays book’s titles with authors from the library table.
SELECT title, author FROM library;
The below SELECT statement displays all data fields from the library table.
SELECT * FROM library;
Database Blog
Firebird SQL Tutor
SQL Select
- Select, Where
- Select, Where Compare
- Select, Where Equal
- Select, Where Greater Than
- Select, Where Less Than
- Select, Where Greater Than, Equal
- Select, Where Less Than, Equal
- Select, Where Not Equal
- Select, Where Between
- Select, Where IN
- Select, Where LIKE
- Select, Where Wildcards
SQL Select AND, OR, NOT
SQL Select ORDER BY
SQL Select DISTINCT
SQL FUNCTIONS
- Functions, Count
- Functions, Sum
- Functions, Avg
SQL RESERVED WORDS
SQL UPDATE
Database Software for Windows:
Handy Managers
Organizer Advantage
Label Printer Advantage
Organizer Advantage Database:
Organizer Advantage, Simple Database Solutions
Organizer Advantage, Business Database Solutions
Copyright © 2024 · All Rights Reserved · PrimaSoft PC