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 73 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.

  • mordiana1506 + 0 comments

    select * from CITY

  • rayedox + 0 comments

    Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

    select * from city

    Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

  • shlshgaikwad + 0 comments

    Why is the compiler so annoying? for such small queries its really pain in the ass to get it right

  • brandon_dicicco + 0 comments

    Very Simple. MS SQL Server

    SELECT * FROM CITY;

  • doting_div + 0 comments

    It's as simple as this:

    SELECT *

    FROM City;

  • anhphan1101 + 0 comments

    SELECT* FROM CITY;

  • anil_h + 0 comments

    SELECT * FROM CITY;

Load more conversations