Basics of SQL Ranking Functions

This is a subject that I didn't know much about until I had to really investigate and use a month ago. Ranking Functions, that is SQL commands to obtain results sets with a column containing some "order" or ranking related information.