单选题

How do you select all the records fro...

Question

How do you select all the records from a table named ‘Persons’ where the ‘LastName’ is alphabetically between (and including) ‘Huang’ and ‘Li’?

A. select * from persons where lastname > ‘Huang’ and lastname < ‘Li’

B. select lastname > ‘Huang’ and lastname < ‘Li’ from persons

C. select * from persons where lastname between ‘Huang’ and ‘Li’