Hql Querys for sql query

Question

Can you give exact hql Query for this Sql query?

SELECT * FROM `ims_product`WHERE
    quantity <= reorder_quantity AND
    reorder_quantity IS NOT NULL AND
    NOT(reorder_quantity=0); 

Answer 1

Try using.

FROM `ims_product` WHERE `quantity` <= `reorder_quantity` AND `reorder_quantity` != 0;