Re: sql question

In article <7aeies$vqp$1_at_nnrp1.dejanews.com>,   josephatl_at_hotmail.com wrote:
> I'd like to run a SQL statement like this:
>
> select alarm_id, switch_id, alarm_time from alarm_db
>
> ...and I'd like it to return the last occurance of this criteria.
>
> How do I do it?
>
> Thanks in advance,
>
> Joe
>
> PS. Anyone know of a good SQL tutorial book/online/cd?

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