How to select only first value

I have a table that include the following columns (except the 'Days between failure', which is part of another question).   Type Serial number Sold_Date Service_Date Failure time (days) Day...