On Fri, 13 Aug 2010 16:41:40 -0700, Josh Berkus <[email protected]> wrote: > On 8/13/10 6:13 AM, erkin tek wrote: > > I'm not on the syntax, I'm on the idea. > > select * from table where id in maxofvalue(id, NumberOfRows, value) > > select * from table where id in random(id, NumberOfRows) > > select * from table where id in lastest(id, NumberOfRows) > > ??? > > Why would you invent new syntax for a query which SQL can do perfectly well?
I am tending to agree.... no engine (except archive... and not efficiently) is going to get a latest row correct... Unless there's a timestamp column in the table anyway. -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
