select h_Level,min(h_Username) as h_Username from managefile where
h_Job='"&rs2("job")&"' group by h_Level order by h_Level desc
h_Job='"&rs2("job")&"' group by h_Level order by h_Level desc
h_level,h_username
1,aa
1,bb
h_Job='"&rs2("job")&"' group by h_Level order by h_Level desc)
没调试,应该没什么问题
你两个都不能丢就必然重复,你先回答阿浩兄的问题先!