Search code examples
mysqlsqlfunctionhql

HQL: greatest between two values

I'm using HQL to query MySQL Database. I am doing somithing like 

SELECT function('GREATEST', column1, column2) as greatest from Table

beacause I want the greatest value between two values in two different column, but it doesn't work. How can I use the SQL function GREATEST in HQL? Thanks

Solution

  • you can use case of if instead of greatest

    case when column1>column2 then column1 else column2 end