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 82 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!

TheNamesImani

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Summary of greenhouse experimental design and results Summary of greenhouse experimental design and results
Pyruvate oxidation results in three changes to pyruvate: Pyruvate oxidation results in three changes to pyruvate:
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.
Earth scientists have devised a scheme to divide the planet’s natural history into distinct time ... Earth scientists have devised a scheme to divide the planet’s natural history into distinct time ...
Nitrogen dioxide decomposes at 300°C via a second-order process to produce nitrogen monoxide ... Nitrogen dioxide decomposes at 300°C via a second-order process to produce nitrogen monoxide ...
Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are
Video: Introduction to Diabetes

For a complete list of videos, visit our video library