MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `Users` (
  `UserID` INT,
  `UserName` varchar(25) ,
  `UserScore` INT );

INSERT INTO Users VALUES 
(1,'John',35),
(2,'Steve',20),
(3,'Chris',40),
(4,'Paul',65),
(5,'Frank',45);




Records: 5  Duplicates: 0  Warnings: 0


select * from Users;


UserID
UserName
UserScore


1
John
35

2
Steve
20

3
Chris
40

4
Paul
65

5
Frank
45


SELECT UserID,
       UserName,
       UserScore,
       MAX(UserScore) OVER () AS ScoreMax
FROM Users
WHERE UserScore > 30 
ORDER BY UserScore


UserID
UserName
UserScore
ScoreMax


1
John
35
65

3
Chris
40
65

5
Frank
45
65

4
Paul
65
65