1. Select all columns from the table
Syntax :- SELECT * FROM table_name;
Ex :- SELECT * FROM my_tab;
2. Select Particular columns the table
Syntax :- SELECT column_name1, column_name2,..............FROM table_name;
Ex :- SELECT name, mobile FROM my_tab;
Example :-