单选题 211人 参与 · 177人 答对 来自： shunwahⓂ️ — 贡献 14 题 写一段SQL，已知衬衫表SHIRTABLE，请你实现通过窗口函数实现，根据不同的衬衫种类shirt_type，按照销售单价shirt_price从低到高的顺序创建排序表（） A SELECT shirt _name, shirt_type, shirt _price，RANK() OVER (PARTITION BY shirt_type) AS rankingFROM SHIRTABLE B SELECT shirt_name, shirt_type, shirt_price，RANK() OVER (PARTITION BY shirt _type ORDER BY shirt_price) AS rankingFROM SHIRTABLE C SELECT shirt _name, shirt_type, shirt _price，PARTITION BY shirt _type ORDER BY shirt _price AS rankingFROM SHIRTABLE D SELECT shirt _name, shirt_type, shirt _price，RANK (PARTITION BY shirt _type ORDER BY shirt _price) AS rankingFROM SHIRTABLE