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

Art and culture of the romans
Which of the following is NOT a function of the digestive system? *
Answer this please I really need help with this homework I'll give you likes
i think that it (rain)....tomorrow
What do foods with no carbohydrates have in common?
Claire bought just enough fencing to enclose either a rectangular garden or a triangular garden, as shown. The two gardens have the same perimeter. How many fee
Cotton and coir are the types of ___________fibres.
If you were in a spaceship travelling at 0.80 c away from a star, at what speed would the star's light pass you? Still travelling at 0.80 c you see another spac
Billy has 1 gallon of paint he’s going to pour it into a paint tray that measures 10 inches wide 14 inches long and 4 cm deep which of the following scenarios w
Please help ASAP!!!!