An Introductory Guide to SQL/

...

/

Quiz 10

Quiz 10

Quiz yourself on conditions and triggers in MySQL.

We'll cover the following...

Question # 1

1.

Which query/queries will return alternate rows from a table containing customer data?

A.
Select customerId from (Select rowId, customerId from customer) where mod(rowId,2)=1
B.
Select customerId from (Select rowId, customerId from customer) where mod(rowId,2)=0
C.
Select customerId from (Select odd(rowId) from customer);
D.
Select alternate(customerId) from customer;
1 / 1