page1

Syntax

Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data. In this tutorial we will use the well-known Northwind sample database (included in MS Access and MS SQL Server). Below is a selection from the "Customers" table:

Id	Name	Age	Country
1	John Doe	25	USA
2	Jane Smith	30	Canada
3	David Lee	40	Australia

SQL Statements :-

• Most of the actions you need to perform on a database are done with SQL statements.
• The following SQL statement selects all the records in the "Customers" table:

Example

Select * From Customer;