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 86 Discussions, By:

votes

  • 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

  • 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!

    • Heraldo + 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...

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

  • a_a_anzida + 1 comment

    select * from CITY group by ID, NAME , COUNTRYCODE , DISTRICT , POPULATION

    • taffarelbergamin + 0 comments

      it doesn't ask to group anything. It just asks for all data in the table.

      SELECT * FROM CITY;

  • artur_ludwik + 0 comments
    SELECT *
FROM CITY

  • Kesharwani_supr1 + 0 comments

    SELECT * FROM CITY

  • zaynabmedia + 0 comments

    select * from city

  • mymanicks1 + 0 comments

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

  • iamtasikul + 1 comment

    MySQL Query is : SELECT * FROM CITY;

    • taffarelbergamin + 0 comments

      All flavours are the same in this one

  • srkunaljagtap + 0 comments

    its an error in your syntax. correct syntax : select * from city

Load more conversations