SQL Oracle PHP Java JSP JDBC MORE

SQL query for data retrieve or select from table


To select or retrieve data from table SELECT statement is used.

SQL SELECT Syntax

SELECT column_name,column_name

FROM table_name;

and

SELECT * FROM table_name;

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.

Example :

SELECT FirstName,LastName

FROM Student;

and

SELECT * FROM Student;