Weather Observation Station 17 | Editorial by aksingh007
All EditorialsSelect min and store in a variable and use it.
```
/*
Enter your query here.
*/
SELECT MIN(LAT_N) INTO @X FROM STATION
WHERE LAT_N>38.7780;
SELECT ROUND(LONG_W,4) FROM STATION
WHERE LAT_N=@X;
```
Select min and store in a variable and use it.
/*
Enter your query here.
*/
SELECT MIN(LAT_N) INTO @X FROM STATION
WHERE LAT_N>38.7780;
SELECT ROUND(LONG_W,4) FROM STATION
WHERE LAT_N=@X;