OrientDB row count

Question

How to get specific row count in Java from Object DB ?

I need to get result for query like : SELECT COUNT(id) FROM Users WHERE banned=true

Answer 1

Try using * as field:

SELECT COUNT(*) as count FROM Users WHERE banned = false