If you're seeing this message, it means we're having trouble loading external resources on our website.

If you're behind a web filter, please make sure that the domains *.kastatic.org and *.kasandbox.org are unblocked.

Main content

SQL: ROUND and other core functions

SQLite (and many SQL engines) comes with a set of core functions that can be used to operate on values. Some of the most popular ones are ROUND, ABS, LENGTH, LOWER, and TRIM. See below for an example of some of those in action.
For a complete list, see the SQLite reference for the core functions.

Want to join the conversation?

No posts yet.