Need a query

• kishoremania

  Ten Centuries

  Points: 1059

  More actions

  September 28, 2011 at 11:29 am

  #245608

  I am showing you dummy data

  select A,B,C from TEST

  Output:

  1011

  1012

  1121

  1122

  1131

  1132

  I need a query to get the record of (11,3,2) from table TEST.

  Can anyone please help me out here.

• kishoremania

  Ten Centuries

  Points: 1059

  More actions

  September 28, 2011 at 11:33 am

  #1387968

  My bad!

  last 2 records are

  12 3 1

  12 3 2

  I need a query to get (12,3,2)

• kishoremania

  Ten Centuries

  Points: 1059

  More actions

  September 28, 2011 at 11:38 am

  #1387970

  answer here

  http://www.sqlservercentral.com/Forums/Topic1182700-392-1.aspx