Infosys interview question

Asked for a SQL statement that would pull specific row based on criteria