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

Answer 2

OrientDB does support SQL like queries and also supports the count(<field>|*) function according to the documentation: http://code.google.com/p/orient/wiki/SQLWhere#Functions