千锋教育-做有情怀、有良心、有品质的职业教育机构

当前位置:首页  >  IT面试题  >  大数据  >  正文

请把下面的HQL语句改为其他方式实现

来源:千锋教育
作者:wjy
关键词: 北京 大连
2022-09-26
分享

请把下面的HQL语句改为其他方式实现

  1)请优化: select a.key,a.value from a where a.key not in (select b.key from b)

  2)已优化: select t1.key,t1.value from ( select a.key,a.value from a ) t1 right join ( select b.key from b ) t2 on t1.key = t2 .key where t1.key is null;

  3)请优化: select a.key,a.value from a where a.key in (select b.key from b)

  4)已优化: select t1.key,t1.value from ( select a.key,a.value from a ) t1 join ( select b.key from b ) t2 on t1.key = t2 .key;

声明:本站稿件版权均属千锋教育所有,未经许可不得擅自转载。

上一篇

下一篇

相关推荐

  • 请把下面的HQL语句改为其他方式实现 1)请优化: select a.key,a.value from a where a.key not in (select b.key from b)  2)已优化: select t1.key,t1.value from ( select a.key,a.value from a ) t1 right join ( select b.key from b ) t2 on t1.key = t2 .key where t1.key is null;