哥哥们求sql

2012-03-26 09:36:38 213 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

lizhilongshandong 墨衍会员 · AI 创作全网分发关注 + 加入社区

SQL必练50题（附答案） - 创建学生表并插入数据INSERT INTO student VALUES(1,'胡图图','男',6);INSERT INTO student VALUES(2,'牛爷爷','男',55);INSERT INTO student VALUES(3,'壮壮妈','女',33);INSERT INTO student VALUES(4,'胡英俊','男',32);INSERT INTO student VALUES(5,'壮壮','男',7); 阅读详情

表1ID有1，3，9
我再往表1插入时 ID我想取2
因为
2没有并且 2是没有中的最小的。。。（2<4<5<6....）

速度啊

...全文

5款高性价比LDO芯片实测对比：从TPS7A4501到LM2940，哪款更适合你的项目？本文通过实测对比了TPS7A4501、TPS72301、LM2937、LM2940等五款高性价比LDO芯片的核心性能。文章详细分析了跌落电压、输出噪声、静态电流及热性能等关键指标，并结合电池供电物联网节点、高精度数据采集等典型应用场景，提供了清晰的选型指南，帮助工程师根据项目需求选择最合适的LDO芯片。阅读详情

lizhilongshandong

Oracle 17,133 成员 55,258 内容

+ 关注 + 加入社区

切换为时间正序

lizhilongshandong 2012-03-26

打赏
举报

当然不固定固定的话还查它干嘛这个题还有约束最大数为99 当达到99时且前面都已填满不再增加
数据ID都以两位数显示

coolkisses 2012-03-26

打赏
举报

楼主的问题，不认为只是这么简单的。
如果只是取固定的一个最小值，手工查一下就可以了，比一堆SQL简单多了。

不固定的话，情况就复杂了。插入多条数据，说白了，就是把缺失的ID补齐，再顺序增加新的ID。

楼主，出来说句话吧。

lizhilongshandong 2012-03-26

打赏
举报

你写的好复杂，，，
select NVL(min(ID+1), 01) yun
from test a
where exists (select Id from test b where a.id = b.id)
and not exists
(select Id from test c where c.id = a.id + 1)

这样行吗？

flyandfade 2012-03-26

打赏
举报

有点错了，修改一下
with a as(
select 1 as id , 'aa' as name from dual union all
select 2 as id , 'bb' as name from dual union all
select 3 as id , 'bb' as name from dual union all
select 5 as id , 'bb' as name from dual union all
select 9 as id , 'cc' as name from dual)
select b.mi
from (select a.id, rownum mi from a order by a.id) b
where b.id <> b.mi
and rownum = 1
order by b.id

flyandfade 2012-03-26

打赏
举报

借用一下兰老师的表
with a as(
select 1 as id , 'aa' as name from dual union all
select 2 as id , 'bb' as name from dual union all
select 3 as id , 'bb' as name from dual union all
select 5 as id , 'bb' as name from dual union all
select 9 as id , 'cc' as name from dual)
select b.mi
from (select a.*, rownum mi from a) b
where b.id <> b.mi
and rownum = 1
order by b.id

yixilan 2012-03-26

打赏
举报

[Quote=引用 1 楼 yixilan 的回复:]
SQL code
with a as(
select 1 as id , 'aa' as name from dual union all
select 2 as id , 'bb' as name from dual union all
select 3 as id , 'bb' as name from dual union all
select 9 as id , 'cc' as ……
[/Quote]
1楼的结果是：4;
如果你的数据是：

with a as(

select 1 as id , 'aa' as name from dual union all

select 3 as id , 'bb' as name from dual union all

select 9 as id , 'cc' as ……

那么运行1楼的结果是：2
--总是取中间不存在的、最小的自然数

yixilan 2012-03-26

打赏
举报

with a as(

select 1 as id , 'aa' as name from dual union all

select 2 as id , 'bb' as name from dual union all

select 3 as id , 'bb' as name from dual union all

select 9 as id , 'cc' as name from dual)

select min(main.id) from

(select sub.id id 

  from 

     (select a_min.a_min, (a_min.a_min+level-1) id 

        from (select min(id) a_min from a )a_min,

             (select max(id) a_max from a )a_max

      connect by level <= a_max.a_max) sub

  where not exists (select 1 from a where a.id = sub.id) 

)main

哥哥们 求sql

相关推荐

哥哥们求sql