Database

Saturday, 6 October 2012

Modifying data

›
It is possible to modify an existing table's data using SQL. There are commands for inserting new data, deleting existing data and modif...

Modifying table structures

›
The ALTER statement can be used in a variety of ways to modify the table structure. It can be used to modify, add, and delete columns. Alter...

CREATE Statement

›
Not only can SQL retrieve data, it can also define data structures and create objects. The create statement can be used to create tables, sc...

SQL

›
SQL - Structured Query Language A programming language designed to manage and access data in a relational DBMS. Popular SQL version or dia...
Tuesday, 4 September 2012

SQL Aggregate Functions

›
There are five aggregate function defined in the ISO standard for SQL. COUNT: Returns the number of values in a specified column. SUM: ...
Wednesday, 29 August 2012

Other SELECT commands

›
There are other commands that can be used with the SELECT statement, such as sorting distinct values, retrieving data from multiple tables a...
Tuesday, 28 August 2012

SELECT with conditions

›
To control which rows of data to retrieve, we can apply various conditions for the table values and only display rows that match that condit...
›
Home
View web version
Powered by Blogger.