{"id":1825,"date":"2026-03-12T20:36:21","date_gmt":"2026-03-12T20:36:21","guid":{"rendered":"https:\/\/htmlplayground.com\/blog\/?p=1825"},"modified":"2026-03-12T20:36:21","modified_gmt":"2026-03-12T20:36:21","slug":"sql-functions","status":"publish","type":"post","link":"https:\/\/htmlplayground.com\/blog\/sql-functions\/","title":{"rendered":"SQL Server Functions with Example Queries"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"sqlfunctionsoverview\">SQL Functions Overview<\/h2>\n\n\n\n<p>In the world of SQL, functions play a crucial role in manipulating and processing data. Functions in SQL serve as powerful tools that allow you to perform various calculations, transformations, and operations on your data. Understanding the importance and types of functions in SQL is essential for harnessing the full potential of this powerful language.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"importanceoffunctionsinsql\">Importance of Functions in SQL<\/h3>\n\n\n\n<p>SQL functions are designed to simplify and streamline the process of working with data. They provide a way to perform complex calculations and operations on data directly within the SQL statements, eliminating the need for additional programming logic or external tools. By leveraging functions, you can enhance the efficiency and effectiveness of your SQL queries.<\/p>\n\n\n\n<p>Functions in SQL offer several key benefits:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Code Reusability<\/strong>: Functions can be reused multiple times within a single query or across different queries, promoting code modularity and reducing redundancy.<\/li>\n\n\n\n<li><strong>Data Consistency<\/strong>: Functions help ensure consistent data manipulation by applying the same logic to multiple rows or tables.<\/li>\n\n\n\n<li><strong>Simplified Queries<\/strong>: Functions enable you to perform complex calculations and operations in a single SQL statement, making your queries more concise and easier to understand.<\/li>\n\n\n\n<li><strong>Increased Performance<\/strong>: By leveraging built-in functions, you can take advantage of optimized and efficient algorithms that are specifically designed for common tasks.<\/li>\n\n\n\n<li><strong>Data Transformation<\/strong>: Functions allow you to transform data on the fly, enabling you to reshape, format, or convert data as needed.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"typesoffunctionsinsql\">Types of Functions in SQL<\/h3>\n\n\n\n<p>SQL provides various types of functions to cater to different data manipulation requirements. The common types of functions include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scalar Functions<\/strong>: Scalar functions operate on a single input value and return a single output value. They are typically used to perform calculations or transformations on individual data points. Examples of scalar functions include <code>ROUND<\/code>, <code>UPPER<\/code>, and <code>CONCAT<\/code>.<\/li>\n\n\n\n<li><strong>Aggregate Functions<\/strong>: Aggregate functions operate on a set of values and return a single value that summarizes or aggregates the data. These functions are used to perform calculations across multiple rows, such as calculating sums, averages, or counts. Examples of aggregate functions include <code>SUM<\/code>, <code>AVG<\/code>, and <code>COUNT<\/code>.<\/li>\n\n\n\n<li><strong>String Functions<\/strong>: String functions are specifically designed to manipulate and analyze string data. They provide operations for string concatenation, substring extraction, case conversion, and more. Examples of string functions include <code>SUBSTRING<\/code>, <code>LOWER<\/code>, and <code>LENGTH<\/code>.<\/li>\n\n\n\n<li><strong>Date and Time Functions<\/strong>: Date and time functions enable you to work with date and time values effectively. These functions allow you to extract components from dates, perform date arithmetic, format date and time values, and more. Examples of date and time functions include <code>DATEPART<\/code>, <code>DATEADD<\/code>, and <code>FORMAT<\/code>.<\/li>\n\n\n\n<li><strong>User-Defined Functions<\/strong>: User-defined functions (UDFs) are custom functions created by users to perform specific tasks. These functions can encapsulate complex logic and calculations, providing a way to extend the functionality of SQL. Examples of user-defined functions include functions for custom calculations or data transformations.<\/li>\n<\/ul>\n\n\n\n<p>By understanding the different types of functions available in SQL, you can leverage the appropriate functions to manipulate and transform your data effectively. Whether you are performing calculations, aggregating data, manipulating strings, or working with dates and times, functions are an indispensable tool in your SQL toolkit. To further enhance your SQL skills, consider exploring our article on <a href=\"https:\/\/htmlplayground.com\/blog\/sql-mastery\/\">SQL Mastery<\/a> for a comprehensive understanding of advanced SQL techniques and applications.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"scalarfunctions\">Scalar Functions<\/h2>\n\n\n\n<p>In SQL, scalar functions play a vital role in manipulating and transforming data within a single row of a table. These functions operate on individual values and return a single result. They are commonly used to perform calculations, modify strings, and manipulate dates and times. Understanding scalar functions is essential for harnessing the full potential of SQL.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"definitionandusage\">Definition and Usage<\/h3>\n\n\n\n<p>Scalar functions in SQL are predefined functions that take one or more arguments and return a single value. They can be used in SELECT statements, WHERE clauses, and other parts of SQL queries to perform various operations on data. Scalar functions are called for each row individually, allowing for dynamic calculations and transformations.<\/p>\n\n\n\n<p>Scalar functions are often used to perform mathematical calculations, such as finding the square root of a number or rounding a value to a specific decimal place. They can also manipulate strings by performing tasks like concatenation, extracting substrings, or converting case. Another common usage of scalar functions is working with date and time values, such as extracting the month or calculating the difference between two dates.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"examplesofscalarfunctions\">Examples of Scalar Functions<\/h3>\n\n\n\n<p>Let&#8217;s explore a few examples of scalar functions to better understand their usage:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Mathematical Functions:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ABS()<\/code>: Returns the absolute value of a number.<\/li>\n\n\n\n<li><code>ROUND()<\/code>: Rounds a number to a specified number of decimal places.<\/li>\n\n\n\n<li><code>SQRT()<\/code>: Calculates the square root of a number.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>String Functions:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>CONCAT()<\/code>: Concatenates two or more strings together.<\/li>\n\n\n\n<li><code>UPPER()<\/code>: Converts a string to uppercase.<\/li>\n\n\n\n<li><code>SUBSTRING()<\/code>: Extracts a substring from a string based on specified starting and ending positions.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Date and Time Functions:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>MONTH()<\/code>: Retrieves the month value from a date or datetime.<\/li>\n\n\n\n<li><code>DATEDIFF()<\/code>: Calculates the difference between two dates.<\/li>\n\n\n\n<li><code>GETDATE()<\/code>: Returns the current date and time.<\/li>\n<\/ul>\n\n\n\n<p>By utilizing scalar functions effectively, you can enhance your SQL queries and manipulate data to suit your specific needs. Familiarize yourself with the different scalar functions available in SQL to unleash the full potential of your database queries.<\/p>\n\n\n\n<p>For a comprehensive understanding of SQL, including the basics, querying data, data manipulation, and more, check out our article on <a href=\"https:\/\/htmlplayground.com\/blog\/sql-mastery\/\">SQL Mastery<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aggregatefunctions\">Aggregate Functions<\/h2>\n\n\n\n<p>In SQL, aggregate functions are powerful tools that allow you to perform calculations on sets of values and return a single result. These functions operate on multiple rows of data and provide valuable insights by summarizing the information in a database table. Let&#8217;s dive into the definition, usage, and examples of aggregate functions in SQL.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"definitionandusage-1\">Definition and Usage<\/h3>\n\n\n\n<p>Aggregate functions in SQL are used to perform calculations on a set of values and return a single value as the result. These functions are commonly used in combination with the <code>SELECT<\/code> statement to generate meaningful summaries of data. Aggregate functions can be used with specific columns or on the entire dataset.<\/p>\n\n\n\n<p>Some popular aggregate functions in SQL include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>COUNT<\/code>: Returns the number of rows or non-null values in a column.<\/li>\n\n\n\n<li><code>SUM<\/code>: Calculates the sum of numeric values in a column.<\/li>\n\n\n\n<li><code>AVG<\/code>: Calculates the average of numeric values in a column.<\/li>\n\n\n\n<li><code>MIN<\/code>: Returns the minimum value from a column.<\/li>\n\n\n\n<li><code>MAX<\/code>: Returns the maximum value from a column.<\/li>\n<\/ul>\n\n\n\n<p>These functions can be applied to different data types, such as numbers, dates, and strings, depending on the specific function and the column being analyzed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"examplesofaggregatefunctions\">Examples of Aggregate Functions<\/h3>\n\n\n\n<p>Here are some examples that demonstrate the usage of aggregate functions in SQL:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Counting the number of employees in a table:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(*) AS TotalEmployees FROM Employees;\n<\/code><\/pre>\n\n\n\n<p>This query uses the <code>COUNT<\/code> function to count the total number of rows in the <code>Employees<\/code> table.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Calculating the total sales for a product:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(Sales) AS TotalSales FROM SalesData WHERE Product = 'Widget';\n<\/code><\/pre>\n\n\n\n<p>The <code>SUM<\/code> function is used here to calculate the total sales for the product &#8216;Widget&#8217; from the <code>SalesData<\/code> table.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Finding the average salary of employees:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT AVG(Salary) AS AverageSalary FROM Employees;\n<\/code><\/pre>\n\n\n\n<p>Here, the <code>AVG<\/code> function is used to compute the average salary of all employees in the <code>Employees<\/code> table.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Determining the earliest and latest hire dates:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT MIN(HireDate) AS EarliestHireDate, MAX(HireDate) AS LatestHireDate FROM Employees;\n<\/code><\/pre>\n\n\n\n<p>The <code>MIN<\/code> and <code>MAX<\/code> functions are employed to find the earliest and latest hire dates in the <code>Employees<\/code> table.<\/p>\n\n\n\n<p>Aggregate functions are a fundamental part of SQL, enabling you to gain insights and extract valuable information from your database. By understanding the usage and capabilities of aggregate functions, you can unleash the potential of SQL and perform powerful data analysis. To enhance your SQL skills further, check out our article on <a href=\"https:\/\/htmlplayground.com\/blog\/sql-mastery\/\">SQL Mastery<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"stringfunctions\">String Functions<\/h2>\n\n\n\n<p>In SQL, string functions play a vital role in manipulating and analyzing text data. These functions enable you to perform various operations on character strings, such as extracting substrings, concatenating strings, changing case, and more. Understanding string functions is essential to harness the full potential of SQL when working with text data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"definitionandusage-2\">Definition and Usage<\/h3>\n\n\n\n<p>String functions in SQL are built-in functions that operate on character strings. They allow you to perform operations like manipulating, searching, and comparing strings within your SQL queries. These functions can be used in SELECT statements, WHERE clauses, and other parts of SQL queries where string manipulation is required.<\/p>\n\n\n\n<p>Here are a few commonly used string functions in SQL:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>LENGTH<\/code> or <code>LEN<\/code>: Returns the length of a string.<\/li>\n\n\n\n<li><code>UPPER<\/code>: Converts a string to uppercase.<\/li>\n\n\n\n<li><code>LOWER<\/code>: Converts a string to lowercase.<\/li>\n\n\n\n<li><code>SUBSTRING<\/code> or <code>SUBSTR<\/code>: Extracts a substring from a string.<\/li>\n\n\n\n<li><code>CONCAT<\/code> or <code>||<\/code>: Concatenates two or more strings.<\/li>\n\n\n\n<li><code>TRIM<\/code>: Removes leading and trailing spaces from a string.<\/li>\n\n\n\n<li><code>REPLACE<\/code>: Replaces occurrences of a substring within a string.<\/li>\n\n\n\n<li><code>LIKE<\/code>: Matches a string against a pattern.<\/li>\n\n\n\n<li><code>INSTR<\/code> or <code>CHARINDEX<\/code>: Returns the position of a substring within a string.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"examplesofstringfunctions\">Examples of String Functions<\/h3>\n\n\n\n<p>Let&#8217;s explore some examples to understand how string functions work in SQL:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Using the <code>LENGTH<\/code> function to get the length of a string:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>   SELECT LENGTH('Hello, World!') AS StringLength;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>StringLength<\/th><\/tr><\/thead><tbody><tr><td>13<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Using the <code>UPPER<\/code> function to convert a string to uppercase:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>   SELECT UPPER('hello, world!') AS UppercaseString;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>UppercaseString<\/th><\/tr><\/thead><tbody><tr><td>HELLO, WORLD!<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Using the <code>SUBSTRING<\/code> function to extract a substring from a string:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>   SELECT SUBSTRING('Hello, World!', 1, 5) AS SubstringResult;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>SubstringResult<\/th><\/tr><\/thead><tbody><tr><td>Hello<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Using the <code>CONCAT<\/code> function to concatenate strings:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>   SELECT CONCAT('Hello', ', ', 'World!') AS ConcatenatedString;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>ConcatenatedString<\/th><\/tr><\/thead><tbody><tr><td>Hello, World!<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>These examples demonstrate just a few of the many string functions available in SQL. By incorporating these functions into your SQL queries, you can manipulate and transform text data to suit your specific needs.<\/p>\n\n\n\n<p>Remember to refer to our comprehensive articles on <a href=\"https:\/\/htmlplayground.com\/blog\/sql-basics\/\">SQL Basics<\/a> and <a href=\"https:\/\/htmlplayground.com\/blog\/querying-data-in-sql\/\">Querying Data in SQL<\/a> for a more in-depth understanding of SQL fundamentals and querying techniques.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"dateandtimefunctions\">Date and Time Functions<\/h2>\n\n\n\n<p>In SQL, date and time functions play a crucial role in manipulating and working with date and time values. These functions allow you to perform various operations on dates, such as extracting specific components, calculating intervals, and formatting dates for display. Let&#8217;s explore the definition, usage, and some examples of date and time functions in SQL.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"definitionandusage-3\">Definition and Usage<\/h3>\n\n\n\n<p>Date and time functions in SQL are used to manipulate and work with date and time values stored in the database. These functions provide a range of capabilities to perform operations like extracting specific parts of a date, calculating differences between dates, and formatting date values.<\/p>\n\n\n\n<p>The usage of date and time functions may vary depending on the specific database management system (DBMS) you are working with. However, most SQL implementations provide a set of common functions that you can utilize to handle date and time data effectively.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"examplesofdateandtimefunctions\">Examples of Date and Time Functions<\/h3>\n\n\n\n<p>To better understand the usage of date and time functions, let&#8217;s take a look at some common examples:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Function<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><code>CURRENT_DATE<\/code><\/td><td>Retrieves the current date from the system.<\/td><\/tr><tr><td><code>CURRENT_TIME<\/code><\/td><td>Retrieves the current time from the system.<\/td><\/tr><tr><td><code>CURRENT_TIMESTAMP<\/code><\/td><td>Retrieves the current date and time from the system.<\/td><\/tr><tr><td><code>DATEPART<\/code><\/td><td>Extracts a specific part (year, month, day, etc.) from a given date.<\/td><\/tr><tr><td><code>DATEADD<\/code><\/td><td>Adds or subtracts a specified interval to\/from a given date.<\/td><\/tr><tr><td><code>DATEDIFF<\/code><\/td><td>Calculates the difference between two dates in a specified interval.<\/td><\/tr><tr><td><code>FORMAT<\/code><\/td><td>Formats a date value to a specific format for display.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Here are some examples of how these functions can be used:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Retrieve the current date\nSELECT CURRENT_DATE;\n\n-- Retrieve the current time\nSELECT CURRENT_TIME;\n\n-- Retrieve the current date and time\nSELECT CURRENT_TIMESTAMP;\n\n-- Extract the year from a given date\nSELECT DATEPART(YEAR, '2022-01-01');\n\n-- Add 7 days to a given date\nSELECT DATEADD(DAY, 7, '2022-01-01');\n\n-- Calculate the number of days between two dates\nSELECT DATEDIFF(DAY, '2022-01-01', '2022-01-10');\n\n-- Format a date value for display\nSELECT FORMAT('2022-01-01', 'MM\/dd\/yyyy');\n<\/code><\/pre>\n\n\n\n<p>These examples demonstrate just a fraction of the date and time functions available in SQL. By utilizing these functions, you can handle date and time data efficiently and perform complex calculations or manipulations as needed.<\/p>\n\n\n\n<p>To further enhance your SQL skills and explore advanced techniques, you can check out our article on <a href=\"https:\/\/htmlplayground.com\/blog\/sql-mastery\/\">SQL Mastery<\/a>. It covers a wide range of topics, including <a href=\"https:\/\/htmlplayground.com\/blog\/querying-data-in-sql\/\">querying data in SQL<\/a>, <a href=\"https:\/\/htmlplayground.com\/blog\/data-manipulation-with-sql\/\">data manipulation with SQL<\/a>, <a href=\"https:\/\/htmlplayground.com\/blog\/joining-tables-with-sql\/\">joining tables with SQL<\/a>, and more.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"userdefinedfunctions\">User-Defined Functions<\/h2>\n\n\n\n<p>In addition to the built-in functions provided by SQL, you have the flexibility to create your own custom functions to meet specific requirements. User-defined functions (UDFs) allow you to encapsulate a set of SQL statements into a reusable function that can be called within your queries. This section will explore the process of creating and implementing user-defined functions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"creatinguserdefinedfunctions\">Creating User-Defined Functions<\/h3>\n\n\n\n<p>To create a user-defined function, you need to define the function name, specify the input parameters (if any), and define the logic or calculations that the function should perform. The basic syntax for creating a UDF is as follows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE FUNCTION function_name (&#91;parameter1 data_type, parameter2 data_type, ...])\nRETURNS return_type\nBEGIN\n    -- Function logic and calculations\nEND;\n<\/code><\/pre>\n\n\n\n<p>Let&#8217;s break down the different components of the syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>CREATE FUNCTION<\/code>: This is the keyword combination used to indicate that you are creating a new function.<\/li>\n\n\n\n<li><code>function_name<\/code>: Replace this with the desired name for your function. Choose a descriptive name that reflects the purpose of the function.<\/li>\n\n\n\n<li><code>[parameter1 data_type, parameter2 data_type, ...]<\/code>: Specify the input parameters for the function, if any. Each parameter should have a name and a data type.<\/li>\n\n\n\n<li><code>RETURNS return_type<\/code>: Define the data type that the function will return. It can be a scalar type, such as integer or string, or even a table type.<\/li>\n\n\n\n<li><code>BEGIN<\/code> and <code>END<\/code>: Enclose the function logic and calculations between these keywords. This is where you write the SQL statements that define the behavior of the function.<\/li>\n<\/ul>\n\n\n\n<p>Once you have written the function definition, you can execute the <code>CREATE FUNCTION<\/code> statement to create the user-defined function. After successfully creating the function, it will be available for use within your SQL queries.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"implementinguserdefinedfunctions\">Implementing User-Defined Functions<\/h3>\n\n\n\n<p>To use a user-defined function in your SQL queries, you can simply call the function by its name and provide the necessary input parameters, if any. The function call can be used within the <code>SELECT<\/code> statement, the <code>WHERE<\/code> clause, or any other appropriate section of your query.<\/p>\n\n\n\n<p>Here&#8217;s an example of calling a user-defined function within a <code>SELECT<\/code> statement:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT column1, column2, function_name(parameter1, parameter2) AS new_column\nFROM table_name;\n<\/code><\/pre>\n\n\n\n<p>In the example above, the user-defined function <code>function_name<\/code> is called with the specified parameters (<code>parameter1<\/code> and <code>parameter2<\/code>). The result of the function is then assigned to a new column, <code>new_column<\/code>, which can be used in further calculations or displayed in the query result.<\/p>\n\n\n\n<p>By creating and implementing user-defined functions, you can extend the capabilities of SQL and tailor the functionality to suit your specific needs. This allows for more efficient and organized SQL code, as well as increased reusability of your functions across multiple queries. To further enhance your SQL skills, you can explore other topics like <a href=\"https:\/\/htmlplayground.com\/blog\/sql-basics\/\">SQL basics<\/a>, <a href=\"https:\/\/htmlplayground.com\/blog\/querying-data-in-sql\/\">querying data in SQL<\/a>, <a href=\"https:\/\/htmlplayground.com\/blog\/data-manipulation-with-sql\/\">data manipulation with SQL<\/a>, and more in our <a href=\"https:\/\/htmlplayground.com\/blog\/sql-mastery\/\">SQL Mastery<\/a> guide.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unleash the potential of SQL functions! Master scalar, aggregate, string, date &#038; time, and user-defined functions for superior database management.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1825","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/posts\/1825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/comments?post=1825"}],"version-history":[{"count":3,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/posts\/1825\/revisions"}],"predecessor-version":[{"id":1886,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/posts\/1825\/revisions\/1886"}],"wp:attachment":[{"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/media?parent=1825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/categories?post=1825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/htmlplayground.com\/blog\/wp-json\/wp\/v2\/tags?post=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}