Re: SQL TRICK. Select rowid, max(...)

Jim Burks (jburks@promus.com) wrote: (...) : I think the current implementation is correct. : MAX() is not a feature of a single row. : Multiple rows may match MAX(col). I didn't write MAX() is a feature of a SINGLE row. It's a feature of a row - that is, any row can have this feature or not. I'm sorry if my english isn't very clear. Of course I know you can achieve goal by self-join, but you have to repeat WHERE clause twice: select ... where <additional conditions> AND field=(select max(field) where <additional conditions second time>) My extension of syntax should avoid that. Thanks for comments. Michal doctorq@sam.nask.com.pl