SQL CONCAT

Write SQL CONCAT query.

The CONCAT function used to add one or more columns in single.

Example

Table: Employee                            
+----+-------+--------+--------------+     
| Id | Name  | Salary | DepartmentId |     
+----+-------+--------+--------------+     
| 1  | Ram   | 85000  | 1            |     
| 2  | Henry | 80000  | 2            |     
| 3  | Sam   | 60000  | 2            |     
| 4  | Shyam | 60000  | 1            |
| 5  | Geeta | 90000  | 1            |
| 6  | Sheet | 90000  | 1            |
| 7  | Leela | 80000  | 1            |
| 8  | Geeta | 70000  | 1            |
+----+-------+--------+--------------+

Approach: Two-column CONCAT

Mysql

SELECT CONCAT(ID,'-',NAME) AS IDNAME FROM EMPLOYEE

Oracle

SELECT CONCAT(CONCAT(ID,'-'),NAME) FROM EMPLOYEE

Result: 

+--------+
| IDNAME |
+--------+
| 1-Ram  |
| 2-Henry|
| 3-Sam  |
| 4-Shyam|
| 5-Geeta|
|6-Sheeta|
|7-Leela |
|8-Geeta |
+--------+

Approach: More than thenTwo-column CONCAT

Mysql

SELECT CONCAT(ID,'-',NAME,'-',SALARY) AS IDNAMESALARY FROM EMPLOYEE

Oracle

SELECT CONCAT(CONCAT(CONCAT(CONCAT(ID,'-'),NAME),'-'),SALARY) as IDNAMESALARY
FROM EMPLOYEE

Result: 

+--------------+
| IDNAMESALARY |
+--------------+
| 1-Ram-85000  |
| 2-Henry-80000|
| 3-Sam-60000  |
| 4-Shyam-60000|
| 5-Geeta-90000|
|6-Sheeta-90000|
|7-Leela-80000 |
|8-Geeta-70000 |
+--------------+