Syntax:
Select
* from <table_name>; --
here * indicates all columns
or
Select
col1, col2, … coln from <table_name>;
Ex:
SQL> select * from
student;
NO NAME MARKS
---
------ --------
1 Sudha 100
2 Saketh 200
1 Jagan 300
2 Naren 400
3 Ramesh
4 Madhu
5 Visu
6 Rattu
SQL> select no,
name, marks from student;
NO NAME MARKS
---
------ --------
1 Sudha 100
2 Saketh 200
1 Jagan 300
2 Naren 400
3 Ramesh
4 Madhu
5 Visu
6 Rattu
SQL> select no,
name from student;
NO NAME
---
-------
1 Sudha
2 Saketh
1 Jagan
2 Naren
3 Ramesh
4 Madhu
5 Visu
6 Rattu
