How to fetch records from mysql database in sorted order with pagination along with group by status

You just need descendingly sort by is_active column, and no need an OFFSET value depending on the explanation such as

  FROM employee 
 ORDER BY is_active DESC, name 

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top