select where distinct code example

Example 1: distincct sql

SELECT DISTINCT column1, column2, ...

 FROM table_name;

Example 2: select distinct

SELECT DISTINCT ma_colonne
FROM nom_du_tableau

Example 3: query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

Example 4: how to select unique element in sql

DISTINCT
- select distinct * from employees; ==> 
  retrieves any row if it has at
  least a single unique column.

- select distinct first_name from employees; ==> 
      retrieves unique names
     from table. (removes duplicates)
     
- select distinct count(*) from employees;
     retrieve number of unique rows
     if any row has at least a single unique data.

Tags:

Csharp Example

Related