Distinct sql

Query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

Select distinct

SELECT DISTINCT ma_colonne
FROM nom_du_tableau

Source: sql.sh

Distinct in sql server

The SELECT DISTINCT statement is used to return only distinct (different) values.
Ex: select DISTINCT Country from TableName;

Sql server select rows by distinct column

SELECT a.*
FROM emails a
INNER JOIN 
  (SELECT email,
    MIN(id) as id
  FROM emails 
  GROUP BY email 
) AS b
  ON a.email = b.email 
  AND a.id = b.id;

Source: stackoverflow.com

Distinct in sql

SELECT DISTINCT FIRST_NAME FROM VISITORS;

Distinct sql

SELECT DISTINCT ColumnName FROM TableName;

Similar codes

1 vote193 views1 answer
ORA-01950
SQL
-1 vote200 views1 answer
Ssql to lowercqse
SQL
0 vote212 views4 answers
How to get max salary in each department in sql
SQL
16 votes200 views3 answers
Tsql rename column name
SQL
0 vote191 views1 answer
Create function syntax sql server
SQL
0 vote213 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes242 views1 answer
Postgresql transaction
SQL
0 vote193 views1 answer
Number(10 2) in sql means
SQL
4 votes194 views1 answer
Change nls_date_format
SQL
1 vote198 views2 answers
Postgresql get difference in hours between two dates
SQL