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;Previous Next
Learn SQL in 16 hrs from experts