Blog

//일반
$row_num = "row_number() over(ORDER BY `board_seq` ASC)";

//상태에 따른 처리(예:숨김 행 따로)
$row_num2 = "row_number() over(PARTITION BY `state` ORDER BY 
CASE 
    WHEN `state` = 'Y' THEN false 
    ELSE 'none' 
END
, `board_seq` ASC)";

$query = "SELECT SQL_CALC_FOUND_ROWS *, $row_num AS `num`, $row_num2 AS `num2` FROM `board` ORDER BY `board_seq` DESC";