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