如何从使用group by命令检索的结果中获取每组中的第一条记录

SELECT *
FROM (
  SELECT *
  FROM your_table
  GROUP BY your_column
  ORDER BY your_column
) AS subquery
GROUP BY your_column

SELECT *
FROM (
  SELECT *,
    ROW_NUMBER() OVER (PARTITION BY your_column ORDER BY your_column) AS row_number
  FROM your_table
) AS subquery
WHERE row_number = 1

SELECT DISTINCT your_column,
  FIRST_VALUE(your_column) OVER (PARTITION BY your_column ORDER BY your_column) AS first_value
FROM your_table