sql - Select most recent InstanceID base on max end date -
i trying pull memberinstance table based on max dateend. if null want pull still ongoing. using sql server. select memberinstanceid table group memberid having max(isnull(date_end, '2099-12-31')) this query above doesnt work me. have tried different ones , have gotten return separate instances, not 1 max date. below table looks like. memberid memberinstanceid datestart dateend 2 abc12 2013-01-01 2013-12-31 4 abc21 ...