MySQL Forums
Forum List  »  MySQL Query Browser

Re: How to write the following query ?
Posted by: Chad Bourque
Date: May 13, 2010 12:27PM

amit,

This query will return two rows (8 and 9) which represent the two series (8, 9, 10 and 9, 10, 11) that meet your criteria:

select a.number
  from blanks a
    join blanks b
      on a.number + 1 = b.number
    join blanks c
      on b.number + 1 = c.number
  where a.Name = ''
    and b.Name = ''
    and c.Name = '';

HTH,
Chad

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.