I'm curious if this is possible at all since a "select * from html" query only returns the body of the document.
Finally found the answer. (EDIT : thanks to Salathe on the YQL forums!)
select * from html where url="http://stackoverflow.com" and xpath='/html/head/title'