请教SQL命令

SELECT member.name, member.gz, member.yue, member.qita
FROM member INNER JOIN
(SELECT name, MIN(gz) AS 最低工资
FROM member AS member_1
GROUP BY name) AS a ON member.name = a.name AND member.gz = a.最低工资

----------------------------------------------
这样可能好理解一点，放入sql2005里运行会变成上面那种形式，结果是一样的
select member.*
from member,(select name,min(gz) as 最低工资 from member group by name) as a
where member.name = a.name AND member.gz = a.最低工资

select name,min(gz) from member group by name

select * from member where gz=(select min(gz) from member);

select * from member order by gz

select name,min(gz)as 最低gz from member group by name order by 最低gz

2种方法均可。

楼上大部分不能查全部信息,试一下这个吧,测试通过的
select A.name,A.gz,A.yue,A.qita from member A
where A.gz=(select min(B.gz) from member B where B.name=A.name
group by B.name)

select * from member as a inner join (select min(gz),name from member group by n