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 vote346 views1 answer
Sql how to duplicate a table
SQL
0 vote330 views1 answer
Convert sql server guid to varbinary
SQL
0 vote357 views1 answer
Find usage of table in sql server
SQL
0 vote332 views1 answer
Update row in sqlite python
SQL
1 vote357 views3 answers
Sql server get week dates from week number
SQL
3 votes336 views4 answers
Mysql create table from select statement
SQL
0 vote354 views1 answer
Mysql aspas simples
SQL
40 votes447 views4 answers
PostgreSQL add column
SQL
1 vote356 views1 answer
Oracle update with sequence
SQL
10 votes349 views5 answers
Between keyword in sql
SQL