SELECT 1 AS id, 'John' AS first_name, NULL AS commission FROM DUAL UNION SELECT 1, 'John' ,NULL FROM DUAL; 请问最后返回什么？
、2 rows
B、1 rows
C、0 rows
D、3 rows
发布时间：2024-07-20 22:56:11
请在 下方输入 要搜索的题目：
推荐参考答案 (
由 百万题库网 官方老师解答 )
答案：B
相关试题
- 1.SELECT 1 AS id, 'John' AS first_name, NULL AS commission FROM DUAL UNION SELECT 1, 'John' ,NULL FROM
- 2.在Oracle中，执行下面的语句，返回值是（） select count(1),count(x),sum(x) from (select null x from dual union all select
- 3.select (null or null),(null or 1),(null || 0),(-8 or 0);
- 4.id=1 and and( )=(select upper ( XMLType (chr ( ) || chr( )||chr( )||(select replace( ),chr( )) from sys.v
- 5.id=1 and and(1)=(select upper(XMLType(chr(60)||chr(58)||chr(58)||(select replace(banner,chr(32),chr(58
- 6.id=1 and and(1)=(select upper ( XMLType (chr (60) || chr(58)||chr(58)||(select replace(banner,chr(32)
- 7.select (NULL<=>NULL) is NULL;的结果为_____
- 8.select (NULL<=>NULL) is NULL;的结果为____。
- 9.select (NULL<=>NULL) is NULL;的结果为_____。
- 10.id=-1’ and (updatexml(1,concat(0x7e,(select ‘333’),0x7e),1)),--+地址二： Http://t.com/?
