Re: SQL TRICK. Select rowid, max(...)
Dima Rasnitsyn (rasnitsn@milcse.rtsg.mot.com) wrote:
: Hi!
: Could anybody suggest me some SQL trick for selecting rowid of row with a max
: value in some column?
: I want to do
: SELECT rowid, max (col1)
: FROM mytable
: WHERE <my conditions>
Try this:
SELECT rowid
FROM mytable
WHERE <my conditions>
ORDER BY col1 DESC
And then fetch one row !
It runs, and it runs fast.
Michal Hobot
doctorQ Computers
doctorq@sam.nask.com.pl