How find the missing number in a sequence. (mysql)

aoEXE
Gangsta

Posts: 789
Threads: 36
Joined: Dec 2013
Reputation: 0

05.02.2016, 04:33

( Последний раз редактировалось aoEXE; 05.02.2016 в 06:41. )

Hey Guys, I would want know if it's possible with a mysql sentence:

Example:

Код:

ID    |     Name

1           Petra
4           Custodio

How would can find missing number between 1 and 4?

That is to say 2, then 3, and then returns 5?

Find

« Next Oldest | Next Newest »

Messages In This Thread

How find the missing number in a sequence. (mysql) - by aoEXE - 05.02.2016, 04:33

Forum Jump:

Users browsing this thread: 1 Guest(s)