Scribd
Upload
17 views8 pages

Function in SQL

SQL functions are pre-written code blocks used to manipulate, extract, and analyze data. They are categorized into aggregate functions, which return a single value from a group of values, and scalar functions, which operate on a single value. Single row functions include numeric, string, and date functions.

Uploaded by

1man squad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views8 pages

Function in SQL

SQL functions are pre-written code blocks used to manipulate, extract, and analyze data. They are categorized into aggregate functions, which return a single value from a group of values, and scalar functions, which operate on a single value. Single row functions include numeric, string, and date functions.

Uploaded by

1man squad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

Function in SQL

In SQL, functions are pre-written code blocks that


perform specific operations on data. They can be
used to manipulate data, extract information, and
analyse data sets. SQL functions are categorized
into aggregate functions, which operate on a
group of values and return a single value, and
scalar functions, which operate on a single value
and return a single value.
SINGLE ROW FUNCTION
● 1. NUMERIC FUNCTION
2. STRING FUNCTION
3. DATE FUNCTION

You might also like