Post reply

Recent date

  • May 27, 2009 at 11:26 am

    #134382

    How do i select recent date in a table. I have table with timestap column where in 10 records are inserted for every 3 days and I would like to pull only latest 10 records.

  • May 27, 2009 at 11:35 am

    #1000861

    This?

    select top 10

    *

    from

    dbo.SomeTable

    order by

    SomeDateTimeColumn desc

  • May 27, 2009 at 11:37 am

    #1000866

    ok i think i have to use max(date).

    thanks

  • May 27, 2009 at 11:44 am

    #1000871

    Tara (5/27/2009)

    ok i think i have to use max(date).

    thanks

    You know what, table DDL, sample data (in a readily comsummable format), and expected results based on the sample data would really help us give you better answers.

    Please read the first article I reference below in my signature block. It provides very good information on how best to post questions like this that get better answers.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply