This article shows how to use a SQL query to perform searching, sorting and paging by one query.
Editorial changes — reviews, status changes and edits — are shown to the author of this article and to the editors.