sql first 2 code example
Example 1: how to fetch first 5 characters in sql
Select SUBSTRING(StudentName,1,5) as studentname from student
Example 2: sql left characters
-- For Oracle only
-- syntax
SUBSTR(<main-string>,1,<number-of-characters>)
-- example
SUBSTR('Useless stuff',1,10) -- OUTPUT: Useless st
-- practical example
SELECT SUBSTR('Useless stuff',1,10)
FROM DUAL;