Answer the question
In order to leave comments, you need to log in
Help writing SQL query
Please, help me write a SQL query or poke your nose - which operators to use
Platform: MySQL
The task is to display unique values, 1 at a time.
I will try to explain in more detail, using the example of a table and the desired result
| name | class | state +-----------------+----------------+ | apple | 1 | true +-----------------+---------------- | big apple | 1 | false +-----------------+---------------- | potatoes | 2 | false +-----------------+---------------- | rotten potatoes | 2 | true +-----------------+---------------- | cherry | 5 | false +-----------------+---------------- | plum | 7 | true +-----------------+----------------
Answer the question
In order to leave comments, you need to log in
use
SELECT DISTINCT {имя_столбца_по которому_необходимо_выводить_уникальные_значения} FROM
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question