Concatinate part of two columnsAdd a column with a default value to an existing table in SQL ServerFetch the row which has the Max value for a columnSQL Server: How to Join to first rowUsing group by on multiple columnsMySQL - Get row number on selectUsing union and order by clause in mysqlSQL select only rows with max value on a columnconcatenate sqlQuery regarding NVL in SQL
King or Queen-Which piece is which?
How do I become a better writer when I hate reading?
Is using Legacy mode is a bad thing to do?
Fill the maze with a wall-following Snake until it gets stuck
Got a new frameset, don't know why I need this split ring collar?
Is this broken pipe the reason my freezer is not working? Can it be fixed?
Leaving job close to major deadlines
Justifying Affordable Bespoke Spaceships
How to sort human readable size
Does anyone recognize these rockets, and their location?
How can the US president give an order to a civilian?
Are there foreign customs agents on US soil?
Having some issue with notation in a Hilbert space
You may find me... puzzling
How much steel armor can you wear and still be able to swim?
First occurrence in the Sixers sequence
How can I maintain game balance while allowing my player to craft genuinely useful items?
How can I prevent a user from copying files on another hard drive?
Is a sequel allowed to start before the end of the first book?
Is there any possible way to get these hearts as Adult Link?
Boundaries and Buddhism
how to find which software is doing ssh connection?
How do credit card companies know what type of business I'm paying for?
Simplify, equivalent for (p ∨ ¬q) ∧ (¬p ∨ ¬q)
Concatinate part of two columns
Add a column with a default value to an existing table in SQL ServerFetch the row which has the Max value for a columnSQL Server: How to Join to first rowUsing group by on multiple columnsMySQL - Get row number on selectUsing union and order by clause in mysqlSQL select only rows with max value on a columnconcatenate sqlQuery regarding NVL in SQL
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
select name,(name,1,3||phone_no,1,3)from users order by (name);
I'm writing a query for the above problem and it is showing error.
Write a to display user name and password. The password should be generated by concatenating first three characters of user name and first three numbers in the phone number and give an alias name as the password. Sort the result based on user name
sql oracle
add a comment |
select name,(name,1,3||phone_no,1,3)from users order by (name);
I'm writing a query for the above problem and it is showing error.
Write a to display user name and password. The password should be generated by concatenating first three characters of user name and first three numbers in the phone number and give an alias name as the password. Sort the result based on user name
sql oracle
add a comment |
select name,(name,1,3||phone_no,1,3)from users order by (name);
I'm writing a query for the above problem and it is showing error.
Write a to display user name and password. The password should be generated by concatenating first three characters of user name and first three numbers in the phone number and give an alias name as the password. Sort the result based on user name
sql oracle
select name,(name,1,3||phone_no,1,3)from users order by (name);
I'm writing a query for the above problem and it is showing error.
Write a to display user name and password. The password should be generated by concatenating first three characters of user name and first three numbers in the phone number and give an alias name as the password. Sort the result based on user name
sql oracle
sql oracle
edited Mar 25 at 10:43
DJo
1,3651936
1,3651936
asked Mar 25 at 5:11
Anu RadhaAnu Radha
94
94
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
remove extra parenthesis and use substring function
select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
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
);
);
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%2f55331559%2fconcatinate-part-of-two-columns%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
remove extra parenthesis and use substring function
select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
add a comment |
remove extra parenthesis and use substring function
select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
add a comment |
remove extra parenthesis and use substring function
select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name
remove extra parenthesis and use substring function
select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name
answered Mar 25 at 5:14
Zaynul Abadin TuhinZaynul Abadin Tuhin
20.8k31338
20.8k31338
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
add a comment |
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
select Schedule_id, travel_date (date format('yyyy/mm/dd')) as FormattedDate from schedule order by (Schedule_id);
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
can uh please correct this one also
– Anu Radha
Mar 25 at 8:33
add a comment |
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.
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%2f55331559%2fconcatinate-part-of-two-columns%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