Kikilcaro6814 Kikilcaro6814
  • 07-01-2020
  • Computers and Technology
contestada

Only one expression can be specified in the select list when the subquery is not introduced with exists. True or False

Respuesta :

dogacandu
dogacandu dogacandu
  • 07-01-2020

Answer:

True

Explanation:

Subquery can not return more than one (multiple) column, because the output can be compared with one column.

For example;

  • SELECT * From Table1 WHERE Column1 IN (SELECT ColumnA FROM Table2)

is a correct statement where

  • SELECT * From Table1 WHERE Column1 IN (SELECT ColumnA,ColumnB FROM Table2)

gives an error.

Answer Link

Otras preguntas

What is the best way to do math problems. Please give me your opinion. 1.a notebook or scratch paper 2.a calculator
Which European power held out in the face of German attacks during the early years of WWII?
list 4 sources of ocean pollution
True or false??? The constitution prohibits the president from giving information or making recommendations to Congress Help pleasee
How to write a thesis statement for an essay about how Christopher Columbus is a villain.
which of the following is not a similarity between green algae and plants
Why does Cassius not want Mark Antony to have the opportunity to speak at Caesar’s funeral? Why does Brutus allow it anyway?
Confucianism and the Government Scholar-officials were privileged with _____________. a. public admiration c. wealthy gifts b. legal leniency d. all of the abov
How did Thomas Aquinas attempt to explain the differences between Aristotle and the Church's teachings?
The range of the following relation R {(3, −2), (1, 2), (−1, −4), (−1, 2)} is