选择行号= rownum的位置 [英] Select where row number = rownum

问题描述

我一直在尝试运行此查询以按行号选择一行，但是我一直在where子句中获取未知列'row'.这个查询可能吗

I have been trying to run this query to select a row by its row number but I keep getting unknown column 'row' in where clause. Is this query possible

SELECT @row := @row + 1 AS row, pi.*
FROM ci_patient_info pi
where row = 2

推荐答案

将其包装在subquery

SELECT c.*
FROM
   (
      SELECT @row := @row + 1 AS row, pi.*
      FROM ci_patient_info pi
   ) c
where c.row = 2

更新1

也许您的子查询应该看起来像这样，

maybe your subquery should look like this,

  SELECT @row := @row + 1 AS row, pi.*
  FROM ci_patient_info pi, (SELECT @row:=0) x

这篇关于选择行号= rownum的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！