Using a CASE statement in HQL select

nhibernate hibernate hql
lomaxx picture lomaxx · Jan 19, 2009 · Viewed 85.1k times · Source

Is there any way to do the following in HQL:

SELECT 
    case when flag = true then SUM(col1) else SUM(col2)
FROM 
    myTable

Answer

Henrik Paul picture Henrik Paul · Jan 19, 2009

I guess you can (3.6, 4.3) [inline edit] ...for where-clauses:

"Simple" case, case ... when ... then ... else ... end, and "searched" case, case when ... then ... else ... end

Related questions

Update several Columns in one Hibernate Query?

i have the Following HQL: String hql = "UPDATE Buchung as b " + "set STORNO = :Storno " + "where ID = :BuchungID"; Is it possible to Update more then one column in a HQL? For Example: String hql = "UPDATE Buchung as b " + "set STORNO = :Storno " + "…

Read More
Using a join in a Hibernate HQL update query

i have the following hibernate mapping: <class name="Domain.Roomreservation, Core" table="Reservationroom"> <id name="ID" unsaved-value="undefined"> <generator class="native"> <!--<param name="sequence">GLOBALSEQUENCE</param>--> &…

Read More
IFNULL equivalent in Hibernate Query Language?

I'm trying to write an HQL query which will calculate an average rating for an item. I want the query to return 0 instead of null when there are no rating for a given item - so that I can use …

Read More