请问sql高手，这条sql语句怎么写？？

Question

如题所述

Answer 1

主键id都是从小到大的，distinct会使一个值只出现一次，故如果有两个相同的值应该是能显示较小的那个；
select
distinct
'年龄',
id,
'姓名'
from
'表名'
group
by
id

Answer 2

SELECT
T1.*
FROM
TABLE
T1
INNER
JOIN
(
SELECT
MIN(ID)
AS
MINID,AGE
FROM
TABLE
GROUP
BY
AGE)
AS
T2
ON
T1.ID
=
T2.ID
ORDER
BY
T1.ID