A
A
Alex2017-05-05 11:19:29
MySQL
Alex, 2017-05-05 11:19:29

Query to exclude identical records with the output of one instance?

Good afternoon.
Whether it is possible to display the data by request, having excluded duplicates?
Or to disassemble everything with the help of cycles in the code?
Let's say there is
testId
1, 2, 3, 10, 8, 4, 5, 6, 3, 4, 1, 5, 7, 9, 11, 6
testId2
7, 9, 10, 8, 4, 1, 2, 3 , 5, 11, 6 5, 6, 3, 4, 1
Result:
testId: 1,2,3,4,5,6,7,8,9,10,11
testId2: 1,2,3,4, 5,6,7,8,9,10,11

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ivan, 2017-05-05
@sensus

2sql.ru/basic/sql-distinct
In some cases Group By

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question