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 84 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

strudel15

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

« previous next »
 

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Macromolecules can have distinct binding sites for multiple ligands Macromolecules can have distinct binding sites for multiple ligands
Select the proper adapter for the compression gauge. The threads on the adapter should match those ... Select the proper adapter for the compression gauge. The threads on the adapter should match those ...
The experimental design and results of Lester and Gorzalka (1988). On the third test, the female ... The experimental design and results of Lester and Gorzalka (1988). On the third test, the female ...
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.
Mg can react with HCl to produce the white solid MgCl2 and H2 gas. A student mixes 1.99 g of ... Mg can react with HCl to produce the white solid MgCl2 and H2 gas. A student mixes 1.99 g of ...
BLAST results showing a 280-base sequence of a chromosome 12 contig from rats BLAST results showing a 280-base sequence of a chromosome 12 contig from rats
Video: Deglutition

For a complete list of videos, visit our video library