 Home
Company
Technologies
Services
Portfolio
Process
Data Warehousing
Contact Us
|
HOME
>> TECHNOLOGY >>SQL
| SQL 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
|
|
| Below is
an example of a table called "Persons": |
|
| Last Name |
First Name |
Address |
City |
| Hansen |
Ola |
Timoteivn
10 |
Sandnes |
| Svendson |
Tove |
Borgvn 23 |
Sandnes |
| Pettersen |
Kari |
Storgt 20 |
Stavanger |
|
|
|
The table above contains three records
(one for each person) and four columns (LastName, FirstName,
Address, and City).
|
| |
| SQL Queries : |
| |
|
With SQL, we can query a database and
have a result set returned.
|
|
| A query
like this : |
|
| SELECT LastName FROM Persons |
|
| |
|
« BACK |
NEXT »
|
| Need more answers; Search Google |
|
|
|
|
|
CREATING SOFTWARE ASSETS
