How Do I Select Data From Table With A Particular Priority

  • DECLARE @Table TABLE

    (minv_code INT,

    alert_msg varchar(10),

    alert_time Datetime)

    INSERT INTO @Table VALUES

    (873939, 'Reverse', '7/24/2015 3:31:18'),

    (873939, 'Tamper', '7/24/2015 3:30:00'),

    (873939, 'Meter', '7/24/2015 3:31:22'),

    (873940, 'Reverse', '7/24/2015 3:30:00'),

    (873940, 'Tamper', '7/24/2015 3:31:22')

    i want to select the data priority wise

    the o/p should look like

    first row - 873939, 'Meter', '7/24/2015 3:31:22'

    second row - 873939, 'Tamper', '7/24/2015 3:30:00'

    third row - 873939, 'Reverse', '7/24/2015 3:31:18'

    fourth row -873940, 'Tamper', '7/24/2015 3:31:22'

    fifth row - 873940, 'Reverse', '7/24/2015 3:30:00'

  • Please do not cross post. It fragments the thread and any answers you may receive.

    Click on this link for original thread.

    http://www.sqlservercentral.com/Forums/Topic1707709-2799-1.aspx

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 2 posts - 1 through 1 (of 1 total)

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