function which should return the max value of int column

Ramco Ramco

2y771SQL

I want a function which should return the max value of int column. Parameter TableName should be passed to the function.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jithu Thomas2y ago

Accepted answer

CREATE PROCEDURE GetMaxValue(IN tableName VARCHAR(255), IN columnName VARCHAR(255))
BEGIN
    SET @query = CONCAT('SELECT MAX(', columnName, ') AS max_value FROM ', tableName);
    PREPARE stmt FROM @query;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END