Re: How to write the following query ?

[Chad Bourque]

Amit,

Well then, you can do it this way:

select a.number - (x - 1)
  from blanks a
    join blanks b
      on a.number between b.number and b.number + x
  where a.Name = ''
    and b.Name = ''
  group by a.number
  having count(*) >= x;

This will return the following for various values of x:

x = 1 => 3, 4, 8, 9, 10, 11
x = 2 => 3, 8, 9, 10
x = 3 => 8, 9
x = 4 => 8

HTH,
Chad