CREATE FUNCTION f_getRowNum()
RETURNS INT
BEGIN
SET @rno = @rno + 1;
RETURN @rno;
END;
CREATE FUNCTION f_rowNum_reset()
RETURNS INTEGER
BEGIN
SET @rno = 0;
RETURN 1;
RETURNS INT
BEGIN
SET @rno = @rno + 1;
RETURN @rno;
END;
CREATE FUNCTION f_rowNum_reset()
RETURNS INTEGER
BEGIN
SET @rno = 0;
RETURN 1;
END;
select f_getRowNum() , s1 from t where f_rowNum_reset() = 1;