通过 SQL, 如何从 Persons 表中查找出 FirstName 字段以 a 开头的所有记录?
1857 次浏览
- A、SELECT * FROM Persons WHERE FirstName LIKE 'a%'
- B、SELECT * FROM Persons WHERE FirstName='a'
- C、SELECT * FROM Persons WHERE FirstName='%a%'
- D、SELECT * FROM Persons WHERE FirstName LIKE '%a'
微信公众号