How to retrieve latest record when date and time are separate ?

From: JN <jirinej_at_volny.cz>
Date: 9 Jul 2003 03:05:23 -0700
Message-ID: <7e29a94a.0307090205.179bca49_at_posting.google.com>

I record attendance of persons to table with these columns: PERSON_ID, DATE, TIME, CODE .
Is it possible to write SQL query, which gives me latest record of all persons? Unfortunately, the DATE and TIME are separate columns. Thanks for any ideas. Received on Wed Jul 09 2003 - 12:05:23 CEST

This message: [ Message body ]
Next message: steve deno: "How to Keep selected text items from being highlighted? In forms 6.0"
Previous message: Val: "Trim number fields as well as blank in SQL LOADER"
Next in thread: JN: "Re: How to retrieve latest record when date and time are separate ?"
Reply: Yasin: "Re: How to retrieve latest record when date and time are separate ?"
Reply: JN: "Re: How to retrieve latest record when date and time are separate ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message