"Database Custom Query" VS "Database Paged Query"

[s.alpaslan]

You can check @jcr ;

Example Queries - Part 2

Paged Query `SELECT id, name, address, phone FROM customers ORDER BY name LIMIT 10 OFFSET 990 Aggregates of specified size Find the values of a table column c1 for which there are a specified number of listed values in another column c2. To get an overview of the values of c2 for each value of c1: SELECT c1, GROUP_CONCAT(c2 ORDER BY c2) AS 'C2 values' FROM table GROUP BY c1; To retrieve a list of c1 values for which there exist specific values in another column c2, you need an IN claus…