Solved programming problem

Show each employees short name that is first 3 letters from the first name followed by an underscore and then followed by the first 3 letters from last_name

Source code

SELECT CONCAT(RPAD(FIRST_NAME,3),"_",RPAD(LAST_NAME,3))

FROM employees;
Join the discussion

Add your comment