子查询结果 'Single Row Sub-Query results more than One Row'

扎希德汗

Office在 Oracle 11g 上的 SQL 终端中创建了一个表


其 3 列分别是
Ename | Bname | salary :-
Ename :雇主的姓名。
Bname :老板姓名
Salary :员工工资。

里面的值 Office Table 是:-

ENAME                BNAME                    SALARY
-------------------- -------------------- ----------
Zahid                Muheet                    30000
Arif                 Muheet                    20002
Ahtishaam            Muheet                    20002
Ayaaz                Muheet                     2000
Zaid                 Muheet                    40000
Muheet               Akib                      40000

6 rows selected.

我想检索所有那些大于或等于 his 的员工 name( ename) salaryboss salary

输出应该是:

ENAME
------
Zaid

我正在我的终端上写一个查询

select emp.ename
from office emp
where emp.salary >= (select a.salary
                     from office a,
                          office b
                     where a.ename = b.bname)

我想它应该可以工作,但会导致错误:

ORA-01427: 单行子查询返回多于一行

纳乔
select emp.ename 
from office emp 
where emp.salary>= ( select boss.salary 
                     from office boss 
                     where emp.bname = boss.ename)

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

PostgreSQL single query SELECT single row FROM two tables without JOIN

来自分类Dev

Ninject - Multiple Classes Using Single Interface (more than one matching bindings are available)

来自分类Dev

Crouton with more than one OS

来自分类Dev

SQL query for selecting foreign-key rows with more than one link to the primary-key table

来自分类Dev

将 mysql 查询转换为 CodeIgniter $query->row

来自分类Dev

在codeigniter中生成row()的查询结果:

来自分类Dev

Join multiple records to one row?

来自分类Dev

How to Select more than WMI Query

来自分类Dev

Remove more than one view on PagerAdapter

来自分类Dev

rating bar not show all star in single row

来自分类Dev

NOT IN nested sub query returns empty set and thus no results for join

来自分类Dev

mysql query based on value of previous row

来自分类Dev

SQL ROW子查询中的比较的订单定义?

来自分类Dev

在子查询中使用 ROW_NUMBER() OVER()

来自分类Dev

CSS classes and ID's on one row

来自分类Dev

In Domain Driven Design, may a transaction modify more than one aggregate?

来自分类Dev

How can I populate more than one zendform?

来自分类Dev

Yii2 Hide Actions in Action Column of a Single Row only

来自分类Dev

Concatenate all the notes in a single row based on lead's ID?

来自分类Dev

Numpy Row by Row 旋转

来自分类Dev

OFFSET()+ ROW()不会给出期望的结果

来自分类Dev

从mysql_fetch_row()中排除结果

来自分类Dev

ROW_NUMBER 计数返回无效结果

来自分类Dev

Row_Number()在联合查询中继续

来自分类Dev

在row_to_json函数中选择查询

来自分类Dev

Microsoft Access查询重复ROW_NUMBER

来自分类Dev

在linq查询中创建Row_Number

来自分类Dev

sql查询与Row_Number不同

来自分类Dev

Row_Number()在联合查询中继续

Related 相关文章

热门标签

归档