sql select only first 10 characters code example
Example 1: get first 3 letters in sql
SELECT FIRST_NAME , SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;
Example 2: how to fetch first 5 characters in sql
Select SUBSTRING(StudentName,1,5) as studentname from student