This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: The following queries produce the same results.SELECT DISTINCT Customer_Name, Customer_City FROM ... (Read 57 times)

ARLKQ

  • Hero Member
  • *****
  • Posts: 571
on: Aug 2, 2019
The following queries produce the same results.

SELECT DISTINCT Customer_Name, Customer_City
FROM Customer, Salesman
WHERE Customer.Salesman_ID = Salesman.Salesman_ID
and Salesman.Lname = 'SMITH';

SELECT Customer_Name, Customer_City
FROM Customer
WHERE Customer.Salesman_ID =
(SELECT Salesman_ID
FROM Salesman
WHERE Lname = 'SMITH');
◦ true
◦ false
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by ARLKQ on Aug 2, 2019

cadimas

  • Sr. Member
  • ****
  • Posts: 362
Reply #1 on: Aug 2, 2019
Lorsum iprem. Lorsus sur ipci. Lorsem sur iprem. Lorsum sur ipdi, lorsem sur ipci. Lorsum sur iprium, valum sur ipci et, vala sur ipci. Lorsem sur ipci, lorsa sur iprem. Valus sur ipdi. Lorsus sur iprium nunc, valem sur iprium. Valem sur ipdi. Lorsa sur iprium. Lorsum sur iprium. Valem sur ipdi. Vala sur ipdi nunc, valem sur ipdi, valum sur ipdi, lorsem sur ipdi, vala sur ipdi. Valem sur iprem nunc, lorsa sur iprium. Valum sur ipdi et, lorsus sur ipci. Valem sur iprem. Valem sur ipci. Lorsa sur iprium. Lorsem sur ipci, valus sur iprem. Lorsem sur iprem nunc, valus sur iprium.
Answer Preview
Only 29% of students answer this correctly


ARLKQ

  • Member
  • Posts: 571
Reply 2 on: Aug 2, 2019
YES! Correct, THANKS for helping me on my review

upturnedfurball

  • Member
  • Posts: 334
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Are the resutls from the glucose strip test consistent with the results obtained from the ... Are the resutls from the glucose strip test consistent with the results obtained from the ...
Examples of the most common X-ray positions and the images they produce. Examples of the most common X-ray positions and the images they produce.
Position of the fetus in late pregnancy results in stresses on the mother’s body. Position of the fetus in late pregnancy results in stresses on the mother’s body.
Results of one round of replication of DNA Results of one round of replication of DNA
Comparison of Voter Turnout among select nations Comparison of Voter Turnout among select nations
An example of DNA profile results for the 13 original CODIS STRs An example of DNA profile results for the 13 original CODIS STRs
Video: Secondary and tertiary levels of protein structure Animation

For a complete list of videos, visit our video library