3 . 3 . Consider a database table named Supplier with a single column LastName shown below....
Fantastic news! We've Found the answer you've been seeking!
Question:
3. Consider a database table named "Supplier" with a single column "LastName" shown below.
Galland
Klingman
Melancon
Gess
Dones
Lamborn
Elizondo
Consider the SQL:
SELECT LastName FROM Supplier
WHERE LastName LIKE "%o%"
ORDER BY LastName
LIMIT 3 OFFSET 1
Write down the order each name will appear in the result. Mention will not appear next to a name if it wont appear in the result.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: