Post reply

Based on Min Timestamp get ID

  • February 8, 2017 at 5:49 pm

    #401584

    I have a table where it has column ID ,startDate.and Type

    I want to write a query that based on minimum timestamp I have to get ID .

    Example of data -
    ID                     StartDate                                    Type
    21                2016-08-07 21:31:59.727                Emp
    22                2016-08-07 21:32:03.883                Emp
    23                2016-08-07 21:32:07.930                Emp
    24                2016-08-07 21:32:12.337                Emp
    25                2016-08-07 21:32:15.977                Emp
    26                2016-08-07 21:32:19.447                Emp

    How to get ID based on min time stamp

  • February 8, 2017 at 11:49 pm

    #1927444

    You've been here over 500 times and can't even post an answerable question with proper sample data??? Please read this article and repost.

  • February 9, 2017 at 2:25 am

    #1927461

    SELECT ID
    FROM #Sample S
    WHERE S.StartDate = (SELECT MIN(sq.StartDate) FROM #Sample sq);

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • February 9, 2017 at 4:41 am

    #1927478


    SELECT TOP(1) ID
    FROM YourTable
    ORDER BY StartDate DESC;

    How to post data/code on a forum to get the best help.

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

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