Find which numbers in [1, 161] are not in the result set?

3 votes

1 answer

2546 views

mysql query mysql-console gaps-and-islands

                          How to find which two number in [1, 161] is not in the result set?

Can I find this two numbers using sql command?

	mysql> select blog_id from wp_blogs;
	
	...

	|     149 |
	|     150 |
	|     151 |
	|     152 |
	|     153 |
	|     154 |
	|     155 |
	|     156 |
	|     157 |
	|     158 |
	|     159 |
	|     160 |
	|     161 |
	+---------+
	159 rows in set (0.25 sec)

**The sequence is from 1 to 161, there should be 161 numbers, but only 159 numbers are in the resultset.**

	mysql> select count(blog_id) from wp_blogs;
	+----------------+
	| count(blog_id) |
	+----------------+
	|            159 |
	+----------------+
	1 row in set (0.24 sec)

How to find the missing numbers?
                        

Asked by hugemeow (159 rep)

Sep 19, 2012, 07:11 PM
Last activity: Sep 19, 2012, 11:05 PM

Find which numbers in [1, 161] are not in the result set?

Related Questions