Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: Select most recent record??

    Hi,

    I want to construct a query that would give the most recent record. Table data looks like -

    F1 F2 F3 F4
    2001 639507 4/7/2004 15:40:55
    2351 639507 4/6/2004 9:31:54

    All columns are strings as the data is obtained from text file. Column F3 can have same or different dates. In the above data select 1st record as it is the most recent.
    If data is like -
    F1 F2 F3 F4
    2001 639507 4/7/2004 15:40:55
    2351 639507 4/7/2004 19:31:54

    Select the 2nd record.

    How do I construct the SQL query?


    Let me know.
    Last edited by vivek_vdc; 04-27-04 at 16:27.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    order by cast(f3+f4 as datetime) desc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •