How Do I Select Data From Table With A Particular Priority

• sushantkatte

  SSChasing Mays

  Points: 647

  More actions

  August 1, 2015 at 12:12 pm

  #299375

  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'

• LinksUp

  SSCertifiable

  Points: 6526

  More actions

  August 1, 2015 at 1:19 pm

  #1816621

  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/