Thanks
I will try this query but I think that will be better use 2 QSqlQuery, one for take the count of registers and the other to get the selected registers with C++ code because it seems that SQL vars doesn't work with QSqlQuery .

Anyway it's a pity that QSqlQuery doesn't support queries like these