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
  • Hiring developers?
  1. Practice
  2. SQL
  3. Basic Select
  4. Select By ID
  5. Discussions

Select By ID

  • Problem
  • Submissions
  • Leaderboard
  • Discussions
  • Editorial

Sort 74 Discussions, By:

votes
  • recency
  • votes

Please Login in order to post a comment

  • meet3698 1 year ago+ 1 comment

    MySQL:

    SELECT * FROM CITY WHERE ID = 1661;

    ORACLE:

    SELECT * FROM CITY WHERE ID = 1661;

    MS SQL Server:

    SELECT * FROM CITY WHERE ID = 1661;

    4|
    Permalink
    • aleung12 1 year ago+ 0 comments

      lol, upvoted

      1|
      ParentPermalink
  • marinskiy 2 years ago+ 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
    FROM CITY
    WHERE ID = 1661;
    

    Feel free to ask if you have any questions :)

    1|
    Permalink
  • abhishek50040 15 hours ago+ 0 comments

    SELECT * FROM CITY WHERE ID = 1661;

    0|
    Permalink
  • rohitharavadasa1 1 week ago+ 0 comments

    select * from city where id=1661;

    0|
    Permalink
  • oniayowole2009 3 weeks ago+ 0 comments

    SELECT * FROM CITY WHERE ID=1661;

    0|
    Permalink
  • jnyh1 2 months ago+ 0 comments

    my solution:

    SELECT *
    FROM CITY
    WHERE ID = '1661';
    
    0|
    Permalink
  • dashingakd 2 months ago+ 0 comments
    SELECT  * FROM CITY 
        WHERE ID = 1661;
    
    0|
    Permalink
  • paul_xerexes07 2 months ago+ 0 comments

    SELECT * FROM CITY WHERE ID=1661

    0|
    Permalink
  • Bader_Alafnan 3 months ago+ 0 comments

    SELECT * FROM CITY WHERE ID = 1661;

    0|
    Permalink
  • shahidzu 3 months ago+ 0 comments

    SELECT * FROM CITY WHERE ID = 1661

    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