find the missing nos in the continues series

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  December 19, 2013 at 9:50 am

  #287625

  Hi There,

  Category Nos

  A 1

  A 2

  A 3

  A 5

  A 6

  A 9

  A 10

  B 23

  B 24

  B 25

  B 27

  B 28

  B 29

  B 31

  Consider the above data...

  I need following output... Help me with query ..

  Category Min Range Max Range

  A 1 3

  A 5 6

  A 9 10

  B 23 25

  B 27 29

  B 31 31

  Logic Behind :

  if any number is missing in the continues series the return the min and max of number in that range.

  Thanks In advance

• Hunchback

  SSCrazy

  Points: 2649

  More actions

  December 19, 2013 at 12:05 pm

  #1674949

  This is the same problem as in your previous question and the solution is the same.

  The expected result doesn't match the title of your post since you are asking for the MIN and MAX values in each island.