Infosys Interview Question

How to use Alter condition in SQL Query