在具有条件的表中查找副本

I have a query such as this:

我有一个这样的查询:

select a.id, a.color, a.shade from colors a where a.color = 'red'
sel