Find Maximum Value WIthout Using Aggregate in SQL
MySQL:
select Numbers from Compare order by Numbers DESC LIMIT 1
SQL Server:
select TOP 1 Numbers from Compare order by Numbers DESC
SELECT DISTINCT Numbers FROM Compare
WHERE Numbers NOT IN (
SELECT Smaller.Numbers FROM Compare AS Larger
JOIN Compare AS Smaller ON Smaller.Numbers < Larger.Numbers
)
Read full article from Find Maximum Value WIthout Using Aggregate in SQL
MySQL:
select Numbers from Compare order by Numbers DESC LIMIT 1
SQL Server:
select TOP 1 Numbers from Compare order by Numbers DESC
SELECT DISTINCT Numbers FROM Compare
WHERE Numbers NOT IN (
SELECT Smaller.Numbers FROM Compare AS Larger
JOIN Compare AS Smaller ON Smaller.Numbers < Larger.Numbers
)
Read full article from Find Maximum Value WIthout Using Aggregate in SQL
No comments:
Post a Comment