There is a third way: keep the data pre-sorted in the database (via an index).

		branko_d on May 3, 2020 \| parent \| context \| favorite \| on: Medium-hard SQL interview questions There is a third way: keep the data pre-sorted in the database (via an index).