Should have noted: Option 1 is only viable if your entire table has no more than a couple of thousand rows (records). Option 2 is possible no matter how big the table is. (And ditto option 3.)
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.