SQLzoo.net

Formatting numbers to two decimal places.

SELECT title, score, FORMAT(score,2)
  FROM movie
  WHERE id <= 10

Related links:

• Concatenate strings.
• Substring: Extracting part of a string.
• lower case
• Finding a substring in a string
• Formatting numbers to two decimal places.
• Replace a NULL with a specific value
• Conditional values
• Get the date and time right now.
• Format dates.