What is the difference between INNER JOIN and OUTER JOIN?

Explain how to sort the rows that are retrieved by a query.?

Moore

Explain how to sort the rows that are retrieved by a query.?

Bauer

Rows that are returned by a query can be sorted using the ORDER BY clause. By default, the rows are sorted in ascending order.
Example:
sql>Select * from emp ORDER BY sal DESC;