The SELECT statement is used to select data from database and retrieve the information.
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 :-
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 :-
.png)
.png)
Posts
0 Comments:
Post a Comment