如何编写查询以选择具有最高向上投票计数的前5行
代码段:
@app.get("/leaderboard/org/", response_model=User, status_code= status.HTTP_200_OK)
async def get_leaderboard_org(skip: int=0,take: int= 5):
query = user_details.select().offset(skip).limit(take)
return await database.fetch_all(query)
@app.get("/leaderboard/org/", response_model=User, status_code= status.HTTP_200_OK)
async def get_leaderboard_org(skip: int=0,take: int= 5):
query = user_details.select().offset(skip).limit(take)
return await database.fetch_all(query)
以下是我的表基本表详细信息
Table:
id Name Org_Name Upvote
1 Sejal Mohata EBIA 10
2 Jayne IT 5
3 Rakesh Nerkar EBIA 2
4 Howard Elias PCF 9
5 Dinesh Khatter IT 6
6 Ishan Rez VMWare 15
7 Uvi Rocker PCF 4
/排行榜/ind的预期产出:
id Name Upvote
6 Ishan Rez 15
1 Sejal Mohata 10
4 Howard Elias 9
5 Dinesh Khatter 6
2 Jayne 5
/排行榜/组织的预期产出:
id Org Upvote
1. VMWare 15
2. PCF 13
3. EBIA 12
4. IT 11
尝试使用
.order_by
和desc
相关问题 更多 >
编程相关推荐