SELECT statement is used to select the data from the database. The syntax is as follows:
SELECT column_name, column_name
This will select the data from the mentioned columns only.
If we want to display whole table, then
SELECT * FROM table_name;
If we want to display the name and roll no. of the students from the table student details, then we use select as follows:
SELECT Name, Roll_no