Infosys interview question

How to use Alter condition in SQL Query