How to use alternative SQL Select statement

Web developer can use the Top clause instead of a Where clause. For example:

SELECT TOP 100 * FROM Orders ORDER_BY ord_date DESC

The database rows will be sorted in descending order by order date, and the first 100 matching results will be retrieved. In this case, it’s the 100 most recent orders. Web developer could also use this type of statement to find information about the most expensive items were sold or the best-performing employees.