CODEWITHSUNDEEP
sqlhibernatehql
Venunadh M
Venunadh M

Reputation: 13

Hql Querys for sql query

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);

Upvotes: 1

Views: 47

Answers (1)

Poorna Senani Gamage
Poorna Senani Gamage

Reputation: 1268

Try using.

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

Upvotes: 1

Related Questions