sql - How to get most recent data? -
i have table 3 pieces of data, facilityname, datelastverified, & intensity. want able pull records recent datelastverified. when datelastverified same, want select record highest intensity.
|facilityname | datelastverified | intensity |nemours/alfred i. dupont hospital children | 2014-03-01 | 16 |boston children's hospital | 2015-11-29 | 6 |boston children's hospital | 2017-04-01 | 3 |tufts medical center | 2017-04-01 | 3 |tufts medical center | 2017-04-01 | 6 so above table i'd want return second entry boston children's hospital , second entry tufts medical center. how write this?
i want able pull records recent datelastverified. when datelastverified same, want select record highest intensity.
based on description, can 1 record using order by , fetch first 1 row only:
select t.* t order datelastverified desc, intensity desc offset 0 row fetch first 1 row only; or sql server:
select top 1 t.* t order datelastverified desc, intensity desc;
Comments
Post a Comment