Author Topic: What are the specific uses of SQL functions?  (Read 343 times)

Offline Filip

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What are the specific uses of SQL functions?
« on: July 10, 2016, 10:04:12 AM »
Hi everyone, I'd like to know something, what are the specific uses of sql functions? That's it, thank you for informing me please as soon as possible. Thank you in advance.
« Last Edit: February 19, 2018, 08:28:18 PM by Sofyene »



Offline Rupert

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: SQL functions
« Reply #1 on: February 19, 2018, 08:30:08 PM »
SQL has many built-in functions for performing processing on string or numeric data. Following is the list of all useful SQL built-in functions −

SQL COUNT Function - The SQL COUNT aggregate function is used to count the number of rows in a database table.

SQL MAX Function - The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.

SQL MIN Function - The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

SQL AVG Function - The SQL AVG aggregate function selects the average value for certain table column.

SQL SUM Function - The SQL SUM aggregate function allows selecting the total for a numeric column.

SQL SQRT Functions - This is used to generate a square root of a given number.

SQL RAND Function - This is used to generate a random number using SQL command.

SQL CONCAT Function - This is used to concatenate any string inside any SQL command.

SQL Numeric Functions - Complete list of SQL functions required to manipulate numbers in SQL.

SQL String Functions - Complete list of SQL functions required to manipulate strings in SQL.


 

Sitemap 1 2 3 4 5 6 7 8 9