Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Joe 25
03 Joe 25
04 Steve 30
05 Steve 30
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Joe Null
03 Joe Null
04 Steve 30
05 Steve Null
SELECT a.ID, a.Name,
CASE
WHEN (a.Dollars) = (SELECT MAX(DISTINCT a.Dollars)
FROM TableA a
WHERE a.Name = b.Name)
THEN (a.Dollars)
ELSE Null
END AS "Max Dollars"
FROM TableA a INNER JOIN TableB b on a.Name = b.Name)
ORDER BY a.ID, a.Name, a."Max Dollars" ASC
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Joe 25
03 Joe 25
04 Steve 30
05 Steve 30
06 Joe 25
07 Joe 25
08 Joe 25
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Steve 30
03 Steve 30
04 Joe 25
05 Joe 25
06 Steve 30
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Joe
50
should be 25
03 Joe 25
04 Steve 30
05 Steve
32
should be 30
06 Steve 30
ID NAME DOLLARS
-- ----------- ------
01 Joe 25
02 Joe 25