MCQs > IT & Programming > SQL >

Suppose you have the following table with columns:

+------+------+------------+--------------------+

| id   | name | work_date  | salary                     |

+------+------+------------+--------------------+

|    1 | John | 2016-01-24 |                300 |

To get an output like '1John2016-01-24' which of the following functions can be used?


SQL MCQs

Suppose you have the following table with columns:

+------+------+------------+--------------------+

| id   | name | work_date  | salary                     |

+------+------+------------+--------------------+

|    1 | John | 2016-01-24 |                300 |

To get an output like '1John2016-01-24' which of the following functions can be used?


Answer

Correct Answer:

CONCAT 

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

SQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it