It is used to get the data those are fulfilling the condition. If the condition is satisfied then only it fetches the data from the table.
The syntax is as follows:
SELECT column1, column2….. FROM table_name WHERE [condition];
Display students name and roll no. those who have scored more than 70.
SELECT Name, Roll_no. From Student_details WHERE marks>70;