contestada

What will be the output of the following query on the table below?


SELECT * FROM “Table1” WHERE (“Name” = ‘Mary’ AND “Name” =‘Joe’)


Table 1

Name Age Gender

Mary 22 female

Joe 24 male

Kate 21 female

A.
Table 1
Name Age Gender
Mary 22 female
Joe 24 male
B.
Name
Mary
Joe
C.
Name Age Gender
D.
Name Age Gender
Mary 22 female
Joe 24 male
Kate 21 female

Respuesta :

dsdrajlin

The output of the query SELECT * FROM “Table1” WHERE (“Name” = ‘Mary’ AND “Name” =‘Joe’) will be C. Name Age Gender

What are the elements of a SQL query?

The main 3 elements are:

  • SELECT: Indicates which columns to return.
  • FROM: Indicates the database to use.
  • WHERE: Indicates the condition.

We have the following query.

  • SELECT * // * Returns all the columns.
  • FROM “Table1” // Uses the Table1.
  • WHERE (“Name” = ‘Mary’ AND “Name” =‘Joe’) // The AND operator displays a record if all the conditions separated by AND are TRUE.

There is no observation for which the "Name" is both "Mary" and "Joe", so the query will be:

C.

Name Age Gender

The output of the query SELECT * FROM “Table1” WHERE (“Name” = ‘Mary’ AND “Name” =‘Joe’) will be C. Name Age Gender

Learn more about SQL here: https://brainly.com/question/25694408

Otras preguntas