How Do You Retrieve The First 5 Characters Of Firstname Column Of Db2

1.	How Do You Retrieve The First 5 Characters Of Firstname Column Of Db2 Table Emp ?
Answer» SQL QUERY : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP; SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

How Do You Retrieve The First 5 Characters Of Firstname Column Of Db2 Table Emp ?

Answer»

SQL QUERY : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;