SQL Select From

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

Ads

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      |
+----------+--------------+

Advertisements

Share on Google+Share on Google+

SQL Select From

Posted on: January 23, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: SQL Select From  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads