To select or retrieve data from table SELECT statement is used.
SELECT values
FROM tables
WHERE conditions;
Here select column_name,column_name specifies only two column data select from table.
SELECT * FROM table_name; query is for select all the data from table.
SELECT *
FROM students;
| NAME | AGE | ADDRESS | PHONE NO |
|---|---|---|---|
| Ritik | 18 | Berhampur | 9668488256 |
| Bilash | 20 | cuttack | 9008434567 |
| Akash | 21 | Bhubaneswar | 8895021341 |
| Nashim | 20 | Kendrapara | 9668434567 |
| Akhilesh | 21 | Baleswar | 8895032456 |