POSTGRESQL 创建表
POSTGRESQL 运算符
POSTGRESQL 选择数据
POSTGRESQL 函数
POSTGRESQL 加入表

Menu
×
×
正确

练习:

编写正确的SQL语句,选择所有品牌为“Ford”且年份大于1970的记录。

SELECT * FROM cars WHERE brand = 'Ford' AND year > 1970;
SELECT * FROM cars WHERE brand = 'Ford' AND year>1970;
SELECT * FROM cars WHERE brand = 'Ford' AND year> 1970;
SELECT * FROM cars WHERE brand = 'Ford' AND year >1970;
SELECT * FROM cars WHERE brand = 'Ford' AND year > '1970';
SELECT * FROM cars WHERE brand = 'Ford' AND year>'1970';
SELECT * FROM cars WHERE brand = 'Ford' AND year> '1970';
SELECT * FROM cars WHERE brand = 'Ford' AND year >'1970';

不正确

点击 此处 重试

正确

下一题 ❯
SELECT * FROM cars
WHERE brand = 'Ford' ;







×

重置分数?