首页 > 试题广场 >

How do you select all the reco

[单选题]

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

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

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

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

查看正确选项

这道题你会答吗？花几分钟告诉大家答案吧！

提交观点

问题信息

2017 算法工程师大数据开发工程师 paypal

上传者：小小

难度：

0条回答 2收藏 553浏览

扫一扫，把题目装进口袋