SELECT DISTINCT in a field that does not appear in the recordset?

Question

I want to do SELECT DISTINCT guid, ..., but I do not want to guidappear in the recordset. How to do it?

Answer 1

Wrap it in a subquery?

select my, interesting, columns
from (
    select distinct GUID, ...
    from ...
)

Answer 2

SELECT a.Field2
     , a.Field3
  FROM (SELECT DISTINCT a.guid
                      , a.Field2
                      , a.Field3
                   FROM table1 a)  a

Answer 3

You can also do

SELECT x, y FROM tbl GROUP BY guid, x, y

The disadvantage here is that you need to duplicate the list of columns in the sentence GROUP BY, which is annoying, but other answers also do.

Answer 4

first select individual values ​​in the temp table.

Then select only the desired values.