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 By ID
  5. Discussions

Select By ID

Sort 64 Discussions, By:

votes

  • meet3698 + 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;

    • aleung12 + 0 comments

      lol, upvoted

  • coder_aky + 0 comments

    100% Working Simple and easy :-)

    SELECT * FROM CITY WHERE ID='1661';

  • mohamedfouda_cs + 0 comments

    SELECT * FROM CITY WHERE ID = '1661';

  • marinskiy + 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 :)

  • swamygowd1199 + 0 comments

    select * from CITY where ID=1661;

  • naik2191 + 1 comment

    MySQL : 

    SELECT * 
FROM CITY 
WHERE 
    ID = 1661
    • fuadashraful16 + 1 comment

      thank you so much

      • naik2191 + 0 comments

        You're welcome!

  • zerotohero + 0 comments
    -- mysql
SELECT * FROM CITY WHERE id=1661

  • kbmanojkumar_201 + 0 comments

    SELECT * FROM city WHERE id=1661;

  • al1609073 + 0 comments

    This is my solution: SELECT *FROM CITY WHERE ID = 1661;

  • sivadrakshrapu + 0 comments

    select * from CITY where ID = 1661;

Load more conversations