The Evil That is "Select *"

Select * may also manifest itself as a memory leak. I worked on realtime data capture system where the previous programmer used select * to select all data and display only the data captured within the past hour. I saw the select *, thought it was strange, but only having limited experience with...