I am using Apache derby database (Client network). I see that when I create table it is created on an instance APP (I don't know if instance is the correct word. sorry of my English). I see that there are other instances (NULLID, SQLJ, SYS, etc).
is there any way to cheat group by -statement or make the query in other way? I mean that query: SELECT userid, name, MAX(age) FROM users GROUP BY name; produces list of the oldest users grouped by the name, but the