Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CASE WHEN data1 > data2 THEN data1 ELSE data2 END AS data, STAMP FROM
- (SELECT STAMP, max(mc.data1) as data1, max(mc.data2) as data2 FROM
- transaction_history mc LEFT JOIN orderdetails gc on mc.id = gc.id where
- gc.order_name in ('xxx','yyy') AND time >= 135689 AND time <= 137692) AS TBL
- org.hibernate.hql.ast.QuerySyntaxException exception saying unexpected token "(".
Add Comment
Please, Sign In to add comment
