Using MS SQL WHERE
In MS SQL, the WHERE function is used to add a condition to the written query. It is one of the most used functions.
Let's have 2 columns named NAME and PRICE in our table called PRODUCTS. We want to fetch the record "Cake" from this table.
| NAME | PRICE |
|---|---|
| Fruit Juice | 5 |
| Cake | 10 |
| Beer | 12 |
| Soda | 8 |
| Water | 6 |
| Salt | 15 |
| Sugar | 16 |
For this, the query we will write should be as follows.
SELECT * FROM PRODUCTS WHERE NAME = 'Cake'