Using count within another select

Question

I get this exception: <AST>:0:0: unexpected AST node: query right-hand operand of a binary operator was null <AST>:0:0: unexpected end of subtree right-hand operand of a binary operator was null

While running this HQL query

select p.nicenumber from thosenumbers p, thesenumbers w where p.datnumber - (select count(*) from thatnumbers b where b.thisnumber = '123' and b.coolnumber = w.coolnumber) > 0

Its a syntax issue since it runs perfectly in my database visualizer

Please include the entire HQL query. Note that just because it is valid SQL does not mean it is valid HQL (though the reverse might be true). — Tim Biegeleisen, Oct 24 '19 at 10:20
i edited it, althought the hql runs fine without: "- (stuff)" — T. Tom, Oct 24 '19 at 10:25

score 0 · Answer 1 · answered Oct 24 '19 at 12:09

0

i was overthinking it and the answer was simply where p.datnumber > (select count(*) from thatnumbers b where b.thisnumber = '123' and b.coolnumber = w.coolnumber)

answered Oct 24 '19 at 12:09

T. Tom

69
1
6

Using count within another select

1 Answers1