如何计算返回的mysql查询组中的行号? [英] How can I count the row number in the returned group of mysql query?

问题描述

如何在返回的mysql查询中获取行号?假设，如果我的查询结果返回了5行，那么我想知道该行是1st，2nd，3rd等.

How can I get the row number in the returned mysql query? Let say, if my query is returning some 5 rows as a result, I want to know that row is 1st,2nd, 3rd etc.

推荐答案

SELECT @row := @row + 1 as row, t.*
FROM some_table t, (SELECT @row := 0) r

这篇关于如何计算返回的mysql查询组中的行号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！