Given this table
CREATE TABLE Compare (
Write a SQL query that will return the maximum value from the “Numbers” column, without using a SQL aggregate like MAX or MIN.
There are two ways to do that, first we can use a self join
SELECT DISTINCT Numbers
Second, which is easier, we can sort and limit the number of returned results.