选择排序和分组 [英] select sort and group by
本文介绍了选择排序和分组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的数据库记录如下: -
My database record is as below:-
展开 | 选择 | Wrap | 行号
推荐答案
你是说你想要一个像这样的查询:
Are you saying that you want a query like:
展开 | 选择 < span class =codeDivider> | Wrap | 行号
这个方法我试过了。无法帮助。
数量设置为3的原因是因为我限制主管将食物限制为3个数量...
this method i had tried. Couldn''t help.
The reason quantity set to 3 is because i limit the chief to cook the food limit to 3 quantities only...
I你对你的数据要求很感兴趣。
你能详细说明其他领域的用途吗?
- 一个订单(107)是一组服务(1) ,1,1,1,1)特定类型的食物? (5,5,5,11,5)?
- 讽刺的目的是什么?它跟踪的内容是什么?
- 数字字段是否总是1 - 因为你没有记录服务的无限0份服务而且每份服务都有自己的条目?
- 此查询的目的是查找厨师一次准备超过 3份的实例吗?
I''m intrigued by your data requirement.
Can you elaborate on the purpose of the other fields?
- Is one Order(107) a group of servings (1,1,1,1,1) of a particular type of food? (5,5,5,11,5)?
- What purpose does cartid serve? What does it track?
- Will the qty field always be 1--since you don''t record the infinite 0 servings served and each serving gets it''s own entry?
- Is the purpose of this query to find instances where cooks prepared more than 3 servings at a time?
这篇关于选择排序和分组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文