给定具有以下各列的表comment minAge maxAge 和以下行:comment, minAge, maxAge "Baby", 1, 5 "Teen", 13, 19 "Adult", 20, 50 是否可以像这样执行sql查询:select * from rows where 16 between minAge and maxAge 结果如下:"Teen", 13, 19 最佳答案 BETWEEN运算符选择范围内的值。值可以是数字,文本或日期。亲自查看表和数据here