Week 6

Question 1

How do you use the Limit Clause?

Answer 1

Select *
FROM TABLEA
LIMIT 2, 7

or

Select *
FROM TABLEB
LIMIT 2

Question 2

How do you delete a subquery?

Answer 2

DELETE FROM TABLEC
WHERE client_ID = (
Select *
FROM clients
WHERE name = “cat thing”
)

Question 3

How do you delete a subquery?

Answer 3

DELETE FROM TABLEC
WHERE client_ID = (
Select *
FROM clients

)

Question 4

w