SQL Where Clause is used to filter Data. For example if we have many products in our items table and we want to see only cars then we are going to use Where Clause in our SQL Query
SYNTAX:
SELECT * FROM TABLENAME WHERE COLUMNNAME = ‘VALUE’
EXAMPLE:
SELECT * FROM ITEMS WHERE ItemName = ‘cars’;
SELECT * FROM ITEMS_SHAHID4 WHERE ITEMNAME = ‘KEYBOARD’;
DESCRIPTION:
WHERE Clause is use to restrict the selection to a specified criteria. The above mentioned example will be used if we want to select only those items where name is car