How to get two rows value

Question

Using mysql

I want to display two rows values in to single value

ID  Name
---------
01  Raja
02  Ravi

Expected output:

01Raja
02Ravi

How to make a query for this condition?

Answer 1

select Concat(ID, Name)
from MyTable

Answer 2

You can call CONCAT:

SELECT CONCAT(CONVERT(ID, VARCHAR(8)), Name)
FROM SomeWhere