MS SQL Server has many inherent capacities to perform handling on string or numeric information. Following is the rundown of all helpful SQL worked in capacities −
- SQL Server COUNT Function − The SQL Server COUNT total capacity is utilized to include the quantity of lines in an information base table.
- SQL Server MAX Function − The SQL Server MAX total capacity permits to choose the most elevated (greatest) esteem for a specific section.
- SQL Server MIN Function − The SQL Server MIN total capacity permits to choose the most reduced (least) esteem for a specific segment.
- SQL Server AVG Function − The SQL Server AVG total capacity chooses the normal incentive for certain table segment.
- SQL Server SUM Function − The SQL Server SUM total capacity permits choosing the absolute for a numeric segment.
- SQL Server SQRT Function − This is utilized to create a square base of a given number.
- SQL Server RAND Function − This is utilized to create an arbitrary number utilizing SQL order.
- SQL Server CONCAT Function − This is utilized to connect various boundaries to a solitary boundary.
- SQL Server Numeric Functions − Complete rundown of SQL capacities needed to control numbers in SQL.
- SQL Server String Functions − Complete rundown of SQL capacities needed to control strings in SQL.