ELT Function in SQL

The ELT string function in Structured Query Language returns the string from the list of string according to the given index number. This function returns NULL, if no string is found at the given index position.

Syntax of ELT String Function

In SQL, we can use the ELT function with the columns of the table, strings, and characters.

Syntax 1:

In this syntax, we used the ELT function with existing table of SQL. Here, we have to define the name and columns of that table on which we want to perform ELT function.

Syntax 2:

In this syntax, we used the ELT function with list of strings.

Syntax 3:

In this syntax, we used the ELT function with list of characters.

Examples of ELT String function

Example 1: The following query uses the ELT function with the list of strings:

Output:

Example 2: The following query searches the "Old" string which is not present in the list of string:

Output:

Example 3: The following SELECT query uses the ELT function with the list of numbers:

Output:

Example 4: This example uses the ELT function with the table in Structured Query Language.

In this fourth example, we will create the new table through which we will perform the ELT function with table values:

The following block shows the syntax to create the new table in SQL:

The following CREATE statement creates the Fresher_Marks table:

The below INSERT queries insert the records of freshers with marks and details in the Fresher_Marks table:

The following SELECT statement displays the inserted records of the above Fresher_Marks table:

Query 1: The following SELECT query uses the ELT function with the First_Name, Middle_Name, Last_Name columns of the above Fresher_Marks table:

This SQL statement shows the value of 3^rd index position of each fresher from the above table.

Output:

Query 2: The following SELECT query uses the ELT function with the Aptitude_Marks, Reasoning_Marks, and Technical_Marks column of those freshers whose Fresher_ID is greater than 502 in the above Fresher_Marks table:

Output: