update with where clause in sql server

SQL WHERE clause is used to specify a condition while fetching the data from a tables.