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'.
Result
+----------+--------------+
| Icard_No | Student_Name |
+----------+--------------+
| 1 | Ajay |
| 2 | Bhanu |
| 3 | Komal |
| 4 | Rakesh |
| 5 | Santosh |
+----------+--------------+
|

|