SELECT p.LastName, p.FirstName
FROM Persons AS p
FROM Persons AS p
WHERE p.LastName='Adams' AND p.FirstName='John'
SQL:
SELECT LastNameAS Family
, FirstNameAS Name
FROM Persons
结果:
Family | Name |
---|---|
Adams | John |
Bush | George |
Carter | Thomas |