Question

Write SQL query for the following:

To display the first five characters of the Name column from STUDENTS table.

Answer 1

SELECT SUBSTR (NAME,1,5) FROM STUDENTS;