SQL SELECT QUERY


SQL SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets.

Syntax:

SELECT * FROM table_name;

Example

CREATE TABLE student(id INT, name VARCHAR(100))
INSERT INTO student VALUES(11211855,'Sachin Yadav')
INSERT INTO student VALUES(11211401,'Sanjay Kumar')
SELECT * FROM student
Output
11211855 Sachin Yadav
11211401 Sanjay Kumar

Share this article on