题解 | #检索并列出已订购产品的清单#
检索并列出已订购产品的清单
https://www.nowcoder.com/practice/9e4741b77f4244149a069883bc0d23be
本题考核的依旧是查找所有不重复的值,同样在对应变量前加上distinct即可。
select distinct prod_id from OrderItems
检索并列出已订购产品的清单
https://www.nowcoder.com/practice/9e4741b77f4244149a069883bc0d23be
select distinct prod_id from OrderItems
相关推荐