is it possible to create a datagrid configuration that generates a query similar to the one above ?1234SELECT id, ..., num_field, (SELECT COUNT(id)+1 FROM tableName t2 WHERE t1.num_field < t2.num_field) as rankFROM tableName t1
“tableName” is the same table.
I need the subquery to get the rank of the record
Thank you !
You must be logged in to reply to this topic.