select table query.
|
indrada...
116
Points
14
Posts
|
Answers
|
Rahul M...
4918
Points
28
Posts
|
Hi Indradaman, Please give more detail, what you want?
Posted On:
08-Mar-2017 04:36
|
||||||||||||||||||||||||||||||||||||||||
|
indrada...
116
Points
14
Posts
|
i have first table and by running select query want answer like second table.
Posted On:
08-Mar-2017 09:40
|
||||||||||||||||||||||||||||||||||||||||
|
Rahul M...
4918
Points
28
Posts
|
Let's do some crazy query: I created 'TestTable' with two field as bellow:
And I want result as:
The query will be like following: SELECT TestTable.id, TestTable.Name, temp.Value
FROM TestTable INNER JOIN (SELECT 'A' AS Name, 1 AS Value
UNION
SELECT 'B' AS Name, 2 AS Value
UNION
SELECT 'C' AS Name, 3 AS Value
UNION
SELECT 'D' AS Name, 4 AS Value
) temp on temp.Name=TestTable.Name
Posted On:
09-Mar-2017 00:54
|
Blog
Active User (3)
