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;








-2















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










share|improve this question






























    -2















    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










    share|improve this question


























      -2












      -2








      -2








      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










      share|improve this question
















      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 25 at 10:43









      DJo

      1,3651936




      1,3651936










      asked Mar 25 at 5:11









      Anu RadhaAnu Radha

      94




      94






















          1 Answer
          1






          active

          oldest

          votes


















          1














          remove extra parenthesis and use substring function



          select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name





          share|improve this answer























          • 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











          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


















          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









          1














          remove extra parenthesis and use substring function



          select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name





          share|improve this answer























          • 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















          1














          remove extra parenthesis and use substring function



          select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name





          share|improve this answer























          • 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













          1












          1








          1







          remove extra parenthesis and use substring function



          select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name





          share|improve this answer













          remove extra parenthesis and use substring function



          select name,substr(name,1,3)|| substr(phone_no,1,3) from users order by name






          share|improve this answer












          share|improve this answer



          share|improve this answer










          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

















          • 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



















          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














          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





















































          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







          Popular posts from this blog

          Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현