We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Select All
  5. Discussions

Select All

Sort 79 Discussions, By:

votes

  • Gashkin + 4 comments

    i am getting the insufficent privileges error

    • Kylelau93 + 1 comment

      insufficent privileges error, is a bug?

      • h_nrj12 + 1 comment

        Yes ! I have the same problem ..

        • davcs86 + 1 comment
          [deleted]
          • cmscott + 1 comment

            I'm getting the same thing

            • swatipriya706 + 0 comments

              same problem here guys....what to do.

    • jvillagran + 1 comment

      it´s an error in your sintaxis.

      • sergiu_lucec + 0 comments

        Heraldo HackerRank Admin 2 years ago

        We have fixed the issue. Apologies for the delay!

    • HeraldoHackerRank Admin + 0 comments

      We have fixed the issue. Apologies for the delay!

    • sahilkhaman + 2 comments

      BRO ONLY TYPE- SELECT * FROM CITY; BECAUSE YOU HAVE TO DISPLAY TABLE IN THIS QUESTION .....

      • rashbingo + 3 comments

        THIS IS WRON (SELECT * FROM CITY). YOU WERE ASKED TO SELECT EACH COLUMN IN A ROLL AND THIS IS HOW IT SHOULD BE DONE. SELECT ID,NAME,COUNTRYCODE,DISTRICT,POPULATION FROM CITY

        • goodtimecruz + 0 comments

          BURN !!! lol

        • sainath_rajput + 0 comments

          Both are same .here '*' refers to all .

        • favianioel + 0 comments

          LOL image

      • faizaliaqat3 + 0 comments

        i do thiz...

  • marinskiy + 1 comment

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
FROM CITY;

    Feel free to ask if you have any questions :)

    • wardarehman + 1 comment

      it says wrong answer when i initially typed this..

      • marinskiy + 0 comments

        Please check it again. It works for all the versions of SQL

  • vikidj + 1 comment

    GRANT RESOURCE TO srun_uDFZN9eqOa error ?

    • samtwining + 1 comment

      I'm getting the same error too. Can't run anything.

      • abhiranjan + 0 comments

        Hi, it has been fixed sometime ago. Thanks for pointing here again.

  • santoshmohapatr1 + 0 comments

    SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY;

  • tpgreene + 0 comments
    SELECT *
  FROM CITY

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

    SELECT *
  FROM CITY;

    (From my HackerRank repo on GitHub.)

  • Jitender98 + 0 comments

    MySQL code-

    SELECT * FROM city;

  • meet3698 + 0 comments

    MySQL:

    SELECT * FROM CITY;

    ORACLE:

    SELECT * FROM CITY;

    MS SQL Server:

    SELECT * FROM CITY;

  • meet3698 + 0 comments

    MySQL:

    SELECT * FROM CITY;

    ORACLE:

    SELECT * FROM CITY;

    MS SQL Server:

    SELECT * FROM CITY;

  • mordiana1506 + 0 comments

    select * from CITY

Load more conversations