Select 2 Column 1 record as 1 column 2 records
-1
I have a table like this
name | place_1 | place_2
jhon | Tokyo | Nagasaki
and I want it to be like this
name | place
jhon | Tokyo
Jhon | Nagasaki
How to Select it in SQL ?
mysql
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
add a comment |
-1
I have a table like this
name | place_1 | place_2
jhon | Tokyo | Nagasaki
and I want it to be like this
name | place
jhon | Tokyo
Jhon | Nagasaki
How to Select it in SQL ?
mysql
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
2
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
3
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table
– Strawberry
Nov 13 '18 at 11:59
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17
add a comment |
-1
-1
-1
I have a table like this
name | place_1 | place_2
jhon | Tokyo | Nagasaki
and I want it to be like this
name | place
jhon | Tokyo
Jhon | Nagasaki
How to Select it in SQL ?
mysql
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
I have a table like this
name | place_1 | place_2
jhon | Tokyo | Nagasaki
and I want it to be like this
name | place
jhon | Tokyo
Jhon | Nagasaki
How to Select it in SQL ?
mysql
mysql
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
edited Nov 13 '18 at 11:57
Suraj Rao
23.2k85770
23.2k85770
asked Nov 13 '18 at 11:55
RidwanRidwan
1
asked Nov 13 '18 at 11:55
RidwanRidwan
1
asked Nov 13 '18 at 11:55
RidwanRidwan
1
1
2
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
3
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table
– Strawberry
Nov 13 '18 at 11:59
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17
add a comment |
2
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
3
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table
– Strawberry
Nov 13 '18 at 11:59
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17
2
2
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
3
3
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table– Strawberry
Nov 13 '18 at 11:59
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table– Strawberry
Nov 13 '18 at 11:59
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17
add a comment |
1 Answer
1
active
oldest
votes
0
Ideally, your expected output should have been your original table structure (and data). You should consider normalizing your data in first place.
Still, if you have no control over the table structure; you can use UNION ALL:
(SELECT name, place_1 AS place
FROM your_table)
UNION ALL
(SELECT name, place_2 AS place
FROM your_table)
ORDER BY name, place DESC
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53280512%2fselect-2-column-1-record-as-1-column-2-records%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Ideally, your expected output should have been your original table structure (and data). You should consider normalizing your data in first place.
Still, if you have no control over the table structure; you can use UNION ALL:
(SELECT name, place_1 AS place
FROM your_table)
UNION ALL
(SELECT name, place_2 AS place
FROM your_table)
ORDER BY name, place DESC
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
add a comment |
0
Ideally, your expected output should have been your original table structure (and data). You should consider normalizing your data in first place.
Still, if you have no control over the table structure; you can use UNION ALL:
(SELECT name, place_1 AS place
FROM your_table)
UNION ALL
(SELECT name, place_2 AS place
FROM your_table)
ORDER BY name, place DESC
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
add a comment |
0
0
0
Ideally, your expected output should have been your original table structure (and data). You should consider normalizing your data in first place.
Still, if you have no control over the table structure; you can use UNION ALL:
(SELECT name, place_1 AS place
FROM your_table)
UNION ALL
(SELECT name, place_2 AS place
FROM your_table)
ORDER BY name, place DESC
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
Ideally, your expected output should have been your original table structure (and data). You should consider normalizing your data in first place.
Still, if you have no control over the table structure; you can use UNION ALL:
(SELECT name, place_1 AS place
FROM your_table)
UNION ALL
(SELECT name, place_2 AS place
FROM your_table)
ORDER BY name, place DESC
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
edited Nov 13 '18 at 12:01
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
answered Nov 13 '18 at 12:00
Madhur BhaiyaMadhur Bhaiya
19.5k62236
19.5k62236
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53280512%2fselect-2-column-1-record-as-1-column-2-records%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
You would already have the required result if you would have normalized your table..that would be a vertical design(just like your required output) instead of horizontally
– B001ᛦ
Nov 13 '18 at 11:57
3
SELECT name, place1 place FROM my_table UNION SELECT name, place_2 FROM my_table– Strawberry
Nov 13 '18 at 11:59
Please see: How to accept an answer for closure. Thanks :)
– Madhur Bhaiya
Nov 14 '18 at 10:07
Ya , i am sorry , but thanks for help .. it fixed for me
– Ridwan
Nov 15 '18 at 5:17