DBMSSQL

FUNCTIONS IN SQL

FUNCTIONS IN SQL

SQL functions that can be used to manipulate data. Such functions can be classified into the following three types:

Arithmetic functions.         Character functions.         Date functions.


Arithmetic functions:

ABS(n)n CEIL(n)

FLOOR(n)

MOD(m,n)

POWER(m,n)


Character functions:

CONCAT(string1, string2)

INITCAP(string)

LOWER(string)

UPPER(string)

SOUNDEX(string)

SUBSTR(string, M, N)


Date functions:

SYSDATE()

ADD_MONTH(D,N)

MONTH_BETWEEN(D1,D2)

TO_CHAR(D, ‘DAY’)


Aggregate functions

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button