如何通过 SQL 从 Persons 表中找出 LastName 字段的值在 Hansen(包含) 和 Pettersen 之间的所有记录?
1352 次浏览
- A、SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
- B、SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
- C、SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
微信公众号