Question : get first 3 letters in sql
Answered by : obedient-ocelot-5tkogtygmlyl
SELECT FIRST_NAME , SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;
Source : | Last Update : Thu, 04 Feb 21
Question : how to fetch first 5 characters in sql
Answered by : obedient-ocelot-5tkogtygmlyl
Select SUBSTRING(StudentName,1,5) as studentname from student
Source : | Last Update : Thu, 04 Feb 21
Question : get first 3 letters in sql
Answered by : vastemonde
-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ; -- Hel
SELECT substr('Hello World', 4, 5) ; -- lo Wo
SELECT substr('Hello World', 4); -- lo World
SELECT substr('Hello World', -3); -- rld
Source : | Last Update : Sun, 09 May 21
Question : fetch first 5 characters of the string in sql
Answered by : abhishek-nr59jygk179t
Select SUBSTRING(names,1,5) as studentName from student
Source : | Last Update : Fri, 28 Jan 22