Tag Archives: SQL-Functions

The SQL Encrypt function is used to encrypt a string using UNIX crypt(). The function is based on Unix crypt() system call, hence it returns… Read More
SQL Functions are developed into Oracle Database and are available to use in various appropriate SQL Statements. Functions in SQL and User defined function in… Read More
The GROUP_CONCAT() function in MySQL is used to concatenate data from multiple rows into one field. This is an aggregate (GROUP BY) function which returns… Read More
The LEAD() and LAG() function in MySQL are used to get preceding and succeeding value of any row within its partition. These functions are termed… Read More
Prerequisite – Aggregate functions in SQL, Joins in SQL Aggregate functions perform a calculation on a set of values and return a single value. Now,… Read More
Following are some of the advanced functions defined in SQL: BIN(): It converts a decimal number to a binary number. Syntax: SELECT BIN(18); Output: BINARY():… Read More
In SQL, dates are complicated for newbies, since while working with a database, the format of the date in the table must be matched with… Read More
In SQL, dates are complicated for newbies, since while working with a database, the format of the date in the table must be matched with… Read More
String functions are used to perform an operation on input string and return an output string. Following are the string functions defined in SQL: ASCII():… Read More
Mathematical functions are present in SQL server which can be used to perform mathematical calculations. Some commonly used mathematical functions are given below: 1. SQRT():… Read More
In some cases, the Server uses data of one type where it expects data of a different data type. This can happen when the Server… Read More
The LAST_DAY() function in MySQL can be used to know the last day of the month for a given date or a datetime. The LAST_DAY()… Read More
In this article, we’ll be discussing some powerful SQL general functions, which are – NVL, NVL2, DECODE, COALESCE, NULLIF, LNNVL and NANVL. These functions work… Read More
Following are Conditional Expressions in SQL The CASE Expression: Let you use IF-THEN-ELSE statements without having to invoke procedures. In a simple CASE expression, the… Read More
Character functions accept character inputs and can return either characters or number values as output. SQL provides a number of different character datatypes which includes… Read More