MySQL Forums
Forum List  »  MySQL Query Browser

How to write the following query ?
Posted by: amit liron
Date: May 13, 2010 09:13AM

Hi,

I use MySql,

I have a table (products) with the following fields (number (primary key), name)
The table order by the number field

for example:


number | Name
-------------
1 | aa
2 | bb
3 |
4 |
5 | ee
6 | ff
7 | gg
8 |
9 |
10 |
11 |
12 | ll
13 | mm



I need to write a query
which need to find 3 numbers
which haven't have a name
and theier number are sequently

for exmple:
in the above example
the answer will be:

8,
9,
10

I use MYSQL,
and I dont know how to right the above query

Thanks

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.