Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Select / SQL Tutor, Select DISTINCT
28/05/2024SQL SELECT DISTINCT statement
The SELECT statement with Distinct
The SELECT DISTINCT statement is used to return only distinct values, all the duplicate rows are removed from the result.
SELECT Distinct syntax
SELECT DISTINCT columnname1, columnname2, ... FROM table_name;
SELECT DISTINCT columnname1 FROM table_name;
SELECT DISTINCT columnname1 FROM table_name;
SELECT Distinct examples
SELECT DISTINCT title, author FROM library;
SELECT DISTINCT title FROM library;
SELECT DISTINCT title 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