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 59 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
Gracias!

JaynaD87

  • Member
  • Posts: 368
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Results of Tracing Methods Results of Tracing Methods
As some groups do ethnic work, they produce a mythical long-lost heritage, as in this photo of ... As some groups do ethnic work, they produce a mythical long-lost heritage, as in this photo of ...
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 ...
Tricyclic antidepressants produce their effects by inhibiting the reuptake of neurotransmitters ... Tricyclic antidepressants produce their effects by inhibiting the reuptake of neurotransmitters ...
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
An electropherogram showing the results of a DNA profile analysis An electropherogram showing the results of a DNA profile analysis
Video: Interview with an Anorexic Woman (Part 2 of 2)

For a complete list of videos, visit our video library