Answers for "how can you fetch first 5 characters of the string sql"

get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Posted by: Guest on January-28-2021

how to fetch first 5 characters in sql

Select SUBSTRING(StudentName,1,5) as studentname from student

Posted by: Guest on January-28-2021

Code answers related to "how can you fetch first 5 characters of the string sql"