SQL Select From

SQL Select From keyword show you the records from a specified table.

SQL Select From

SQL Select From

     

SQL Select From keyword show you the records from a specified table.

Understand with Example

The Tutorial illustrate an example from 'SQL Select From'. To understand and example we create a table 'Stu' with specified fieldnames and datatypes in the below query.

 

 

 

Create Table Stu:

Create Table Stu(Id int,Name Varchar(15));

Insert values into Stu:

The insert into is used to add the records or rows to the table 'stu'.

Insert Into Stu values(1,'Ajay');
Insert Into Stu values(2,'Bhanu');
Insert Into Stu values(3,'Komal');
Insert Into Stu values(4,'Rakesh');
Insert Into Stu values(5,'Santosh');

Query

The select keyword in SQL is used to show the records from table 'Stu'.

select * from Stu;

Result

+----------+--------------+
| Icard_No | Student_Name |
+----------+--------------+
| 1        | Ajay         |
| 2        | Bhanu        |
| 3        | Komal        |
| 4        | Rakesh       |
| 5        | Santosh      |
+----------+--------------+