SQL Oracle PHP Java JSP JDBC MORE

SQL query for data retrieve or select from table

❮ Previous Next ❯

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;

❮ Previous Next ❯