Skip to content

Category Archives: SQL

LEFT() function in MySQL is used to extract a specified number of characters from the right side of a given string. It uses its second… Read More
1. Select into : Suppose a table has some particular rows that has to be transferred to another table of the same database. It can… Read More
1. DVar() Function : DVar() Function in MS Access is used to estimate variance across a set of values in a specified set of records… Read More
1. ASIN Function : In MariaDB, the ASIN function is used for finding arc sine of a number. In this function, a number will be… Read More
SUBSTRING_INDEX() function in MySQL is used to return a substring from a string before a specified number of occurrences of the delimiter. Syntax : SUBSTRING_INDEX(… Read More
BIT_LENGTH() function in MySQL is used to find the length of a given string in bits. The input string can be a character string or… Read More
CHAR_LENGTH() function in MySQL is used to find the length of a given string (in characters). It counts the number of characters and ignore whether… Read More
Table variable is a type of local variable that used to store data temporarily, similar to the temp table in SQL Server. Tempdb database is… Read More
1. ATAN() Function : ATAN() function in MySQL is used to return the arc tangent of any number x. The arctangent of x is defined… Read More
It is the solution or process or technology to make the service or application or database availability 24×7 and 100% through needless and fault-tolerant components… Read More
In this article, we are going to cover ASCII function with examples and you will see the ASCII MYSQL query. And will also cover ASCII… Read More
In this article, we are going to cover DateSerial() and DateValue() Function in MS Access with examples and will cover DateSerial and DateValue query with… Read More
A database has a vast collection of data stored in an organized format. A database might contain a variety of data values stored in it.… Read More
1. TimeValue() Function : In MS Access, the TimeValue() function returns the time based on the given string. In this function, the string will be… Read More
In this article, we are going to cover ELT function with examples. In ELT function, number field will state that how many strings will be… Read More