在插入语句中选择语句. [英] select statment in an insert statement.

问题描述

大家好，

在插入语句中是否可以有一条选择语句.

例如

Hi All,

Is it possible to have a select statement in a insert statement.

e.g

INSERT INTO Employees ( Names, Surname, hours)
VALUES ( 'Nicole',
         'Naidoo', 
   SELECT avg(hours) FROM worktimes WHERE wdate >sysdate-7 AND employee_no = '10265'); 

我试过了，但是没用.

谢谢

Nicole

I tried this but it doesnt work.

Thanks

Nicole

推荐答案

为您选择的查询另加括号:

Make separate bracket for your select query:

INSERT INTO Employees ( Names, Surname, hours)
VALUES ( 'Nicole',
'Naidoo',
(SELECT avg(hours) FROM worktimes WHERE wdate >sysdate-7 AND employee_no = '10265'));

查询语法错误.

尝试

The query syntax is wrong.

Try instead

INSERT INTO Employees ( Names, Surname, hours)
SELECT 'Nicole', 'Naidoo', avg(hours) FROM worktimes WHERE wdate >sysdate-7 AND employee_no = '10265';

您需要使用方括号:

You need brackets:

INSERT INTO Employees ( Names, Surname, hours)
VALUES ( 'Nicole',
         'Naidoo', 
         (SELECT avg(hours) FROM worktimes WHERE wdate >sysdate-7 AND employee_no = '10265')
       ); 

这篇关于在插入语句中选择语句.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！