Also an index on the alarm_time column may make it quicker.
bret_at_sybase.com wrote in message <7aepdf$6bc$1_at_nnrp1.dejanews.com>...
>In article <7aeies$vqp$1_at_nnrp1.dejanews.com>,
> josephatl_at_hotmail.com wrote:
>How about:
>
> select alarm_id, switch_id, alarm_time from alarm_db
> where alarm_time = (select max(alarm_time) from alarm_db)
>
>
>As a beginners guide, I happen to like "The Practical SQL Handbook" by
Bowman,
>Emerson, and Darnovsky. Published by Addison Wesley.
>--
>Bret Halford
>Sybase, Inc.
>3665 Discovery Drive
>Boulder, CO 80303
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Feb 18 1999 - 00:00:00 CST
