@hazardwarning The duplicates are likely because you’re asking to see columns that have the same info for multiple rows. You might want to try SELECT DISTINCT. Here’s an example of duplicate rows: Table T has rows A and B where column C1 is A resp B and column C2 is 2 for both. Select C2 from T will then show 2 and 2, since both rows are part of the result set, but the Select asked only to see column C2, which is identical for both of them. To collapse duplicates, you can Select DISTINCT C2 from T. This

@hazardwarning The duplicates are likely because you’re asking to see columns that have the same info for multiple rows. You might want to try SELECT DISTINCT.

Here’s an example of duplicate rows:

Table T has rows A and B where column C1 is A resp B and column C2 is 2 for both.

Select C2 from T will then show 2 and 2, since both rows are part of the result set, but the Select asked only to see column C2, which is identical for both of them.

To collapse duplicates, you can Select DISTINCT C2 from T. This will remove duplicates.

2018-04-18T13:42:07Z