I have table data after doing all joins and restrictions like this:

I want the result table to look like this in the end:

What SQL (mySQL) feature can be used to get such a result?

So far, I've had to do data processing (mapping) in the code that calls this request.

CodePudding user response：

We can use conditional aggregation here:

SELECT
    Name,
    MAX(CASE WHEN Type = 'mobile'  THEN Path END) AS Path_Mobile,
    MAX(CASE WHEN Type = 'desktop' THEN Path END) AS Path_Desktop
FROM yourTable
GROUP BY Name
ORDER BY Name;

CodePudding user response：

SELECT  DISTINCT(MT.[Name]),
        MT2.[Path] AS DesktopPath,
        MT3.[Path] AS MobilePath
FROM    MyTable MT
INNER JOIN MyTable MT2
        ON MT2.[Name] = MT.[Name] AND MT2.[Type] = 'DESKTOP'
INNER JOIN MyTable MT3
        ON MT3.[Name] = MT.[Name] AND MT3.[Type] = 'MOBILE'