-- writing two values of a row together just as we write in starting
-- it is similar to concatenation in string 
create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),salary int);
insert into employee(EmpID, EmpFirstName, EmpLastName, Address, Salary)
values(1,"John","Doe","Delhi",10000),
(2,"Collins","john","Chandigarh",20000),
(3,"Johny","Doey","Delhi",10000),
(4,"Collinsy","johny","Chandigarh",20000),
(5,"Harryy","Jonesy","Delhi",15000); 
select EmpFirstName ||" " || EmpLastName from employee;
select EmpID || " " || EmpFirstName from employee;