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.
select top 1 CITY,min(len(CITY)) len from STATION group by CITY order by len asc;
select top 1 CITY,max(len(CITY)) len from STATION group by CITY order by len desc;
Just getting in to SQL Server and was poking around for a clear example of how to implement variables - thanks for this! Seeing this implementation helped me connect some dots.
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
I customised it for MS SQL Server as below:
DECLARE @V1 VARCHAR(MAX)
DECLARE @V2 VARCHAR(MAX)
DECLARE @V3 VARCHAR(MAX)
DECLARE @V4 VARCHAR(MAX)
SET @V1 = (SELECT MIN(LEN(CITY)) FROM STATION);
SET @V2 = (SELECT TOP 1 CITY FROM STATION WHERE LEN(CITY) = @V1 ORDER BY CITY );
SET @V3 = (SELECT MAX(LEN(CITY)) FROM STATION);
SET @V4 = (SELECT TOP 1 CITY FROM STATION WHERE LEN(CITY) = @V3 ORDER BY CITY );
SELECT @V2,@V1; SELECT @V4,@V3;
select top 1 CITY,min(len(CITY)) len from STATION group by CITY order by len asc; select top 1 CITY,max(len(CITY)) len from STATION group by CITY order by len desc;
Thank you
Just getting in to SQL Server and was poking around for a clear example of how to implement variables - thanks for this! Seeing this implementation helped me connect some dots.