22,209
社区成员
发帖
与我相关
我的任务
分享
--查询方式1
SELECT [姓名],[年龄],[班级],[手机] FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY [姓名],[年龄] ORDER BY [姓名]) AS ID,* FROM student
)a WHERE a.ID=1
---查询方式2
SELECT * FROM student WHERE student.%%physloc%% IN (SELECT MIN(student.%%physloc%%) FROM student GROUP BY [姓名],[年龄] )