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

2 votes422 views3 answers
Sql delete duplicate
SQL
3 votes394 views1 answer
Laravel paginate raw sql
SQL
0 vote342 views1 answer
Psql not found windows
SQL
1 vote385 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote417 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote375 views1 answer
Insert data from stored procedure into table
SQL
0 vote334 views1 answer
Add sqlite3 in lumen
SQL
11 votes342 views2 answers
Set default column value sql
SQL
0 vote342 views1 answer
Mysql replication change database name
SQL
0 vote389 views1 answer
Transaction and commit trong sql server
SQL