How can I check whether my sql script extracts data right or not

What are methodologies or best practices for checking sql (or hql, even if I use spark for extracting data) script result?