DotNet: Select Statement in SQL

Basic SQL Syntax

SELECT Statement:

Select Statement used to retrieve the data from database (table)

and the results are displays in table format, called Result-set

Syntax for retrieving all data from table:

SELECT * FROM table_name;

Syntax for retrieving Selected Column data from table:

SELECT Columnname(s) FROM table_name;

Examples:

The Table “Contact” has following data,

We use following statement,

SELECT * FROM Contact;

The Result-set is,

We use following statement,

SELECT Name,Designation,Mobile FROM Contact;

The Result-set is,

Note that, SQL is not Case-Sensitive.

DotNet