Describe some SQLite aggregate functions?

devquora
devquora

Posted On: Feb 22, 2018

 

The SQLite aggregate functions are the functions where values of multiple rows and columns are grouped as input and form a single value as output.
Below is the list of SQLite aggregate functions:
  • SQLite MIN function: It is used to select a minimum value for a column.
  • SQLite MAX function: It is used to select a maximum value for a column.
  • SQLite SUM function: It is used to select the total for a numeric column.
  • SQLite AVG function: It is used to select the average value for a table column.
  • SQLite COUNT function: It is used to count the number of rows in a database table.
  • SQLite UPPER function: It is used to convert a string into upper-case letters.
  • SQLite LOWER function: It is used to convert a string into lower-case letters.
  • SQLite LENGTH function: It is used get the length of a string.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQLite interview questions

    What is SQLite and where is it used?

    The SQLite is mostly ACID (Atomicity, Consistency, Isolation, and Durability) compliant relational database management ..

    SQLite interview questions

    Distinguish between SQLite and SQL?

    SQLite: It is a well built, embedded relational database management system that is mostly used in mobile devices for da..

    SQLite interview questions

    Mention some SQLite commands and also explain them?

    The SQLite commands interact directly with relational databases and are similar to SQL. Below are the standard SQLite c..