SELECT *
FROM artists
WHERE nationality IS NULL
ORDER BY artist_id
LIMIT 10;
上述语句 SELECT * 选取所有列,
WHERE nationality IS NULL
选取case中nationality为空值的行。
ORDER BY artist_id
LIMIT 10;
以 artist_id 为排列方式,降序,限制只显示10个值。
SELECT *
FROM artists
WHERE nationality IS NULL
ORDER BY artist_id
LIMIT 10;
上述语句 SELECT * 选取所有列,
WHERE nationality IS NULL
选取case中nationality为空值的行。
ORDER BY artist_id
LIMIT 10;
以 artist_id 为排列方式,降序,限制只显示10个值。