In this article, you will learn how to write a basic SQL query ... optional ORDER BY sorts the result, and finally, the TOP or OFFSET-FETCH clauses select a limited number of rows to return.