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...
  • Practice
  • Compete
  • Jobs
  • Leaderboard
  1. Practice
  2. SQL
  3. Basic Select
  4. Select All
  5. Discussions

Select All

  • Problem
  • Submissions
  • Leaderboard
  • Discussions
  • Editorial

Sort 84 Discussions, By:

votes
  • recency
  • votes

Please Login in order to post a comment

  • marinskiy 9 months ago+ 1 comment

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
    FROM CITY;
    

    Feel free to ask if you have any questions :)

    6|
    Permalink
    • wardarehman 9 months ago+ 1 comment

      it says wrong answer when i initially typed this..

      -1|
      ParentPermalink
      • marinskiy 9 months ago+ 0 comments

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

        0|
        ParentPermalink
  • Gashkin 4 years ago+ 4 comments

    i am getting the insufficent privileges error

    6|
    Permalink
    • Kylelau93 4 years ago+ 1 comment

      insufficent privileges error, is a bug?

      3|
      ParentPermalink
      • h_nrj12 4 years ago+ 1 comment

        Yes ! I have the same problem ..

        0|
        ParentPermalink
        • davcs86 4 years ago+ 1 comment
          [deleted]
          0|
          ParentPermalink
          • cmscott 4 years ago+ 1 comment

            I'm getting the same thing

            2|
            ParentPermalink
            • swatipriya706 4 years ago+ 0 comments

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

              0|
              ParentPermalink
    • jvillagran 4 years ago+ 1 comment

      it´s an error in your sintaxis.

      0|
      ParentPermalink
      • sergiu_lucec 2 years ago+ 0 comments

        Heraldo HackerRank Admin 2 years ago

        We have fixed the issue. Apologies for the delay!

        0|
        ParentPermalink
    • Heraldo 4 years ago+ 0 comments

      We have fixed the issue. Apologies for the delay!

      0|
      ParentPermalink
    • sahilkhaman 4 years ago+ 2 comments

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

      3|
      ParentPermalink
      • rashbingo 3 years ago+ 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

        -20|
        ParentPermalink
        • goodtimecruz 3 years ago+ 0 comments

          BURN !!! lol

          0|
          ParentPermalink
        • sainath_rajput 2 years ago+ 0 comments

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

          0|
          ParentPermalink
        • favianioel 2 years ago+ 0 comments

          LOL image

          3|
          ParentPermalink
      • faizaliaqat3 3 years ago+ 0 comments

        i do thiz...

        -2|
        ParentPermalink
  • vikidj 4 years ago+ 1 comment

    GRANT RESOURCE TO srun_uDFZN9eqOa error ?

    2|
    Permalink
    • samtwining 4 years ago+ 1 comment

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

      1|
      ParentPermalink
      • abhiranjan 4 years ago+ 0 comments

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

        0|
        ParentPermalink
  • Kesharwani_supr1 11 hours ago+ 0 comments

    SELECT * FROM CITY

    0|
    Permalink
  • zaynabmedia 11 hours ago+ 0 comments

    select * from city

    0|
    Permalink
  • mymanicks1 3 days ago+ 0 comments

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

    0|
    Permalink
  • iamtasikul 6 days ago+ 0 comments

    MySQL Query is : SELECT * FROM CITY;

    0|
    Permalink
  • srkunaljagtap 1 month ago+ 0 comments

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

    0|
    Permalink
  • santoshmohapatr1 2 months ago+ 0 comments

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

    0|
    Permalink
  • tpgreene 2 months ago+ 0 comments
    SELECT *
      FROM CITY
    
    0|
    Permalink
Load more conversations

Need Help?


View editorial
View top submissions
  • Contest Calendar
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy
  • Request a Feature