Re: SQL question

 Hi ,

 select name,value1,value2,time from table a  where time = (select max(time) from table b where a.name = b.name)

  This we have tested on Sybase 10.0 it works and you try it out.

 rajesh.p Received on Mon Jan 15 1996 - 05:08:25 CST