Answers for "sql right"

SQL
2

left() in sql

#LEFT(string, number_of_chars)

#Extract 3 characters from a string (starting from left):
SELECT LEFT('SQL Tutorial', 3) AS ExtractString;
#Result -> SQL
Posted by: Guest on September-08-2021
0

sql right characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;
Posted by: Guest on May-12-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language