True/False
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');
Correct Answer:

Verified
Correct Answer:
Verified
Q17: All of the following are part of
Q25: A join that is based upon equality
Q35: Explain how to combine queries using the
Q37: If the DBA wishes to describe all
Q54: A subquery in which processing the inner
Q55: The following code would include: <br>SELECT Customer_T.CustomerID,CustomerName,
Q69: Explicit commands to manage transactions are needed
Q72: The following code is an example of
Q76: The advantages of SQL-invoked routines are flexibility,
Q77: RANK and DENSE-RANK are examples of:<br>A) ceilings.<br>B)