Inserting into table from select statement and hardcoded values

Question

I am trying to do something like this:

INSERT
INTO
  my_test
  (
    name,
    sirname,
    Dept
  )
  VALUES
  (('First Name'),(SELECT sirname, Dept FROM my_test_backup WHERE dept = 500));

The error I am getting is too many values.

Answer 1

If you want to insert a hardcoded value make it part of the select.

insert into my_test
   (name, sirname, dept)
   (select 'First Name'
          ,sirname
          ,dept
      from my_test_backup
     where dept = 500)