1. Úvodná stránka
  2. SQL

Získajte odlišných hodnôt v mysql

Príklady kódu

4
0

N

SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/
3
0

N

When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.

Here is the syntax of the DISTINCT clause:

SELECT DISTINCT
    select_list
FROM
    table_name;

Podobné stránky

Podobné stránky s príkladmi

V iných jazykoch

Táto stránka je v iných jazykoch

Русский
..................................................................................................................
Ссылка
English
..................................................................................................................
Link
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Populárne v tejto kategórii

Populárne stránky s príkladmi v kategórii

mysql jedinečné hodnoty
jedinečné dáta na ľavom stĺpci skupiny sql
sql select distinct stĺpec
vyberte jedinečný riadkov v mysql
sql dostať iba jedinečné hodnoty
ako sa k vybrať duplicitné riadky v sql
sql pre každú jedinečnú hodnotu v stĺpci
mysqli odlišné
odlišné id a text sql server
získať jedinečný riadok v sql
sql odlišné záznamy id
odlišné jednej oblasti sql
odlišné pre jeden stĺpec v sql
odlišný počet sql
sql odlišné vyberte
inej funkcie v jazyku python w3schools