Sql语句求最小可用id
select id from test a where not exists
(
select 1 from test where id=a.id+1
)
order by id
缺点,不从1开始计算。
原创文章,作者:starterknow,如若转载,请注明出处:https://www.starterknow.com/114419.html
select id from test a where not exists
(
select 1 from test where id=a.id+1
)
order by id
缺点,不从1开始计算。
原创文章,作者:starterknow,如若转载,请注明出处:https://www.starterknow.com/114419.html