Sunday, December 21, 2014

SQL basics - ( SELECT ) - (For absolute beginners) - Tutorial 2

Concatenation 

SELECT first_name||' '||PHONE_NUMBER FROM employees;



SELECT 'The phone no of of Mr.'
  ||first_name
  ||' '
  ||last_name
  ||' is '
  ||PHONE_NUMBER AS "Employee Details"
FROM EMPLOYEES;


2

No comments:

Post a Comment