之前面试面到过,也是搜了好久,发现可以用加行号的方式解决该问题
首先有一张表,有三个字段goods,name,price,有这样一个需求:
需要查询每个人购买最贵的5个商品有哪些?
分析:(也就是按人名分类取出前5个贵的商品)
表结构:
插入语句:
insert into shopping (goods, name, price) VALUES ("笔","小明",20.00);
insert into shopping (goods, name, price) VALUES ("杯子","小明",100.00);
insert into shopping (goods, name, price) VALUES ("花","小红",10.00);
insert into shopping (goods, name, price) VALUES ("车子","小红",100000.00)