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

doctorq@sam (DoctorQ Komputery i Programy) writes: >We've discussed problem with max() function with friends and we think that >SQL syntax should be extended: >There should be 'IS MAX' clause in WHERE section, similarly to 'IS NULL' >clause. >For example: >select rowid from table where col is max This is available using a self-join. SELECT t1.rowid FROM table t1 WHERE t1.col = (SELECT MAX(t2.col) FROM table t2); (Aliasing the table names isn't required in this case; I _always_ do it in a self-join for my own sanity.)