Hi, Yes, could you please provide a complete example script (including "create table" and "insert" statements)?
Regards, Thomas On Wed, Feb 12, 2014 at 7:25 AM, Alex <[email protected]> wrote: > hi, > > there is a field in a table > > dat DATETIME NULL DEFAULT CURRENT_TIMESTAMP > > > select max(dat) from t1 > group by item > > gives a expected result, however > > select * from t1 where dat in ( select max(dat) from t1 > group by item) > > returns full t1 > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
