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…..
Display students name and roll no. those who have scored more than 70.
SELECT Name, Roll_no.