SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.SomeTable (ID tinyint, SomeNumber tinyint);
INSERT INTO dbo.SomeTable
VALUES(1,1),
      (2,2),
      (3,3),
      (4,4),
      (5,5);
5 rows affected

SELECT MIN(SomeNumber) OVER (ORDER BY SomeNumber) AS MinSomeNumber,
       MAX(SomeNumber) OVER (ORDER BY SomeNumber) AS MaxSomeNumber
FROM dbo.SomeTable
ORDER BY ID;


MinSomeNumber
MaxSomeNumber


1
1

1
2

1
3

1
4

1
5


SELECT MIN(SomeNumber) OVER (ORDER BY SomeNumber) AS MinSomeNumber,
       MAX(SomeNumber) OVER (ORDER BY SomeNumber DESC) AS MaxSomeNumber,
       MIN(SomeNumber) OVER (ORDER BY SomeNumber ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS MinSomeNumber,
       MAX(SomeNumber) OVER (ORDER BY SomeNumber ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS MaxSomeNumber,
       MIN(SomeNumber) OVER () AS MinSomeNumber,
       MAX(SomeNumber) OVER () AS MaxSomeNumber
FROM dbo.SomeTable
ORDER BY ID;


MinSomeNumber
MaxSomeNumber
MinSomeNumber
MaxSomeNumber
MinSomeNumber
MaxSomeNumber


1
5
1
5
1
5

1
5
1
5
1
5

1
5
1
5
1
5

1
5
1
5
1
5

1
5
1
5
1
5


DROP TABLE dbo.SomeTable;