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 58 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
Thanks for the timely response, appreciate it

rachel

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Results are shown for proteins denatured by two different environmental changes Results are shown for proteins denatured by two different environmental changes
Results from sequential study of two cohorts tested at three ages and at three different points in t Results from sequential study of two cohorts tested at three ages and at three different points in t
Monitoring and Following Up on Laboratory Test Results Monitoring and Following Up on Laboratory Test Results
An AC voltage is produced by a magnetic sensor. Most sensors should produce at least 0.1 volt AC ... An AC voltage is produced by a magnetic sensor. Most sensors should produce at least 0.1 volt AC ...
F1 and F2 results of Mendel’s dihybrid crosses F1 and F2 results of Mendel’s dihybrid crosses
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: Interview with an Anorexic Woman (Part 2 of 2)

For a complete list of videos, visit our video library