Answers for "sql select min value from multiple rows"

t-sql select min from two values

SELECT
PaidForPast=(SELECT MIN(x) FROM (VALUES (PaidThisMonth),(OwedPast)) AS value(x))

Posted by: Guest on April-02-2020

sql select max value from multiple rows

SELECT name,price FROM fake_apps
WHERE price = (SELECT max(price) FROM fake_apps);

Posted by: Guest on August-24-2021

Code answers related to "sql select min value from multiple rows"