In essence, yes it is possible, but exactly how depends on a number of factors.
Firstly there is your selection criteria - or how you pick which records you want to retrieve, and which you don't.
Secondly, it depends on how you store your information. If you want to select based on a date for example, then if you store your "compdate" field as a string it is difficult to do.
Assuming that you r fields are sensibly stored, and your selection criterisa is "on or after 13th december last year" then
SELECT location, userid, totdays FROM tblCompOff WHERE compdate >= '2012-12-13'
would do it. The WHERE clause specifies the selection criteria.