着急，问个子查询的问题，在线等

hero--008

接触MYSQL较少，对其子查询不太熟悉，我在oracle的一个语句，麻烦哪位帮我改下，谢谢
with s as(select Z_eqid,max(Z_eqtime) Z_eqtime from Equipment_Record where p.Z_uid='9000' group by Z_eqid )
select p.Z_eqid,p.Z_equsetype,p.Z_eqtime from Equipment_Record p where p.Z_eqid=s.Z_eqid and p.Z_eqtime=s.Z_eqtime

[ 本帖最后由 hero--008 于 2009-11-23 19:12 编辑 ]

hero--008

那位XDJM帮忙转换下啊！！！

hero--008

已解决：
select p.Z_eqid,p.Z_equsetype,p.Z_eqtime from  
(select Z_eqid,max(Z_eqtime) Z_eqtime from Equipment_Record where Z_uid='9000' group by Z_eqid) as s ,
Equipment_Record p where p.Z_eqid=s.Z_eqid and p.Z_eqtime=s.Z_eqtime
标红的与oracle有点不同！大部分还是一样的