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

    HackerRank

  • |
  • Prepare
  • Certify
  • Compete
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 16
  5. Discussions

Weather Observation Station 16

Problem
Submissions
Leaderboard
Discussions

Sort 598 Discussions, By:

recency

Please Login in order to post a comment

  • myuvaraj008
    6 hours ago+ 0 comments

    SELECT ROUND(MIN(LAT_N),4) FROM STATION WHERE LAT_N > 38.7780

    0|
    Permalink
  • engrhaidermkhan1
    1 day ago+ 0 comments

    SELECT ROUND(MIN(LAT_N), 4) FROM STATION WHERE LAT_N >38.7780; or SELECT ROUND(LAT_N,4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N ASC LIMIT 1

    0|
    Permalink
  • priyanka_bopche1
    3 days ago+ 0 comments

    MS SQL SERVER

    SELECT CAST(round(MIN(LAT_N),4) as numeric(12,4)) FROM STATION WHERE LAT_N > 38.7780;

    0|
    Permalink
  • manoj_kulkarni21
    4 days ago+ 0 comments

    MY SQL SELECT ROUND(MIN(LAT_N),4) FROM STATION WHERE LAT_N>38.7780;

    0|
    Permalink
  • nhipham117
    4 days ago+ 0 comments

    MySQL

    SELECT ROUND(LAT_N,4)
    FROM STATION
    WHERE LAT_N > 38.7780
    ORDER BY LAT_N ASC
    LIMIT 1
    
    0|
    Permalink
Load more conversations

Need Help?


View top submissions
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy