Re: sql query`

From: Walt <walt_askier_at_YourShoesyahoo.com>
Date: Thu, 23 Dec 2004 10:38:50 -0500
Message-ID: <eEByd.537$iN.472@news.itd.umich.edu>

Michel Cadot wrote:
> "Marcelo" <mcecci_at_yahoo.it> a écrit dans le message de news:F4yyd.325299$b5.15749663_at_news3.tin.it...
> |
> | the last record...
> |
> | select * from table1 where rowid = (select max(rowid) from table1)
> |
>
> The worst answer we had for a while!

Right. It will appear to work just long enough for it to make it in to production. But it'll almost certainly break at some point, probably at the worst possible moment.

--Walt Received on Thu Dec 23 2004 - 09:38:50 CST