Skip to content

Tag: sql

SQL query for most recent date

I’m trying to query to only pull the most recent sale date but keep the unique value of “strap”. This is the query result I have. nh_cd strap dor_cd acreage sqft sale date …

Find unique subset

I’m trying to query 4 columns A, B, C and D to find records where there is more than 1 D per A/B. Relationship is hierarchical from A to D; there can be multiple Ds per C, multiple Cs per B etc. e.g. …