Use query within the value of another query

Question

It is possible - with some syntax adaptation - to fulfill the objective of the following query?

insert into X (a, b) values(16, select c from Y where d = e)

Answer 1

You can use the quotes for such a need, thus creating a Subquery.

One Subquery is basically one query within another. When working with subquerys, we should be aware of certain points, such as the case that a subquery can return more than one value, causing your sql query to generate an error (my experience is based only on databases mssql and oracle, so I don’t know what the behavior of other databases).

Example:

insert into X (a, b) values(16, (select c from Y where d = e))

Answer 2

insert into X (a, b) 
select 16, c from Y where d = e

You can do so too, without the word values.

Answer 3

You don’t even need to put the word Values, just keep the values inside the select. So:

insert into X (a, b) (select "16", c from Y where d = e)