Is it possible to insert a row using the INSERT function on a queried table?

Question

INSERT INTO (
    SELECT student_info.Student_Name,scores.Final
    FROM student_info 
    INNER JOIN scores ON scores.Student_id=student_info.Student_id 
        AND scores.Subject_id=1)
(Student_Name,Final) VALUES("a",1)

Something like this.....What i want to achieve is that i want to add a new row to the queried result which will display the average of the columns above it.

You can't insert into multiple tables in a single operation. — Barmar, Mar 25 '17 at 09:13
If that's not what you're trying to do, I can't figure out what this question is asking. — Barmar, Mar 25 '17 at 09:15
Instead of the 1 in the values, I wanted to insert the average.....I am yet to figure that part out — Sai, Mar 25 '17 at 09:24
`INSERT` is for adding a row to a table. Which table do you want to insert into? — Barmar, Mar 25 '17 at 09:39
It's not a table that I wish to insert into but the queried result — Sai, Mar 26 '17 at 05:47
What does it mean to insert into results? If you want to add additional rows to a result, use `UNION` to combine two queries. — Barmar, Mar 27 '17 at 14:53

Barmar · Answer 1 · 2017-03-27T14:56:41.637

1

Use UNION to combine the results of two queries into a single result:

SELECT student_info.Student_Name,scores.Final
FROM student_info 
INNER JOIN scores ON scores.Student_id=student_info.Student_id 
    AND scores.Subject_id=1

UNION

SELECT "a", AVG(scores.Final)
FROM student_info 
INNER JOIN scores ON scores.Student_id=student_info.Student_id 
    AND scores.Subject_id=1

edited Mar 27 '17 at 14:56

answered Mar 25 '17 at 09:42

Barmar

741,623
53
500
612

ScaisEdge · Answer 2 · 2017-03-25T09:46:31.650

0

if you need an insert select you could use this way

INSERT INTO your_table_name  (Student_Name,Final)
SELECT student_info.Student_Name,scores.Final
FROM student_info 
INNER JOIN scores ON scores.Student_id=student_info.Student_id 
AND scores.Subject_id=1

and eventually if need a added row you can add an union clause with the literal value to your select

INSERT INTO your_table_name   (Student_Name,Final)
SELECT student_info.Student_Name,scores.Final
FROM student_info 
INNER JOIN scores ON scores.Student_id=student_info.Student_id 
AND scores.Subject_id=1
union all  
select "a", 1
from dual;

edited Mar 25 '17 at 09:46

answered Mar 25 '17 at 09:22

ScaisEdge

131,976
10
91
107

You need a table name after `INSERT INTO`. – Barmar Mar 25 '17 at 09:38
@scaisEdge In my case, I wish to insert row into a queried result.......is it possible to name the queried result?? – Sai Mar 26 '17 at 05:49
[Student_Name,Final] [a, 25] [b, 58] [c, 67] [d, 46] After my query this is my result(^) and i wish to add a row in this saying Average 49 – Sai Mar 26 '17 at 05:51

Is it possible to insert a row using the INSERT function on a queried table?

2 Answers2