Category "jcr-sql2"

How to apply aggregate functions(like MIN, MAX, COUNT) in JCR-SQL2?

I have some records stored as Nodes in JCR and the name of the node is the primary key. eg 1,2,3. But the problem starts here, the records are as follows 1,2,6