Answers for "sql query to fetch first 5 character of a string"

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 "sql query to fetch first 5 character of a string"