Number of rows in OrientDB

Question

How to get a specific number of rows in Java from an object database?

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

+5

Jhon Jul 05 '12 at 8:19

2 answers

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

+1

csupnig Jul 05 '12 at 8:26

Lvca · Accepted Answer · 2012-07-05T11:58:18+0000

Try using * as a field:

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