word looked up :

Structured Query Language : SQL

Structured Query Language, or SQL, is a programming language for use in quasi-relational databases. Many of the original SQL features were inspired by, but in violation of, tuple calculus, but recent extensions to SQL include a more relational algebra flavour.

SQL was originally created by IBM, but many vendors developed dialects of it. It was adopted as a standard by ANSI in 1986 and ISO in 1987.

SQL was revised in 1992, and that version is known as SQL-92. It was again revised in 1999 to become SQL:1999 (AKA SQL3). SQL:1999 supports objects, which weren't previously supported in other versions, but as of late 2001, few database management systems implement SQL:1999.

SQL, although defined by both ANSI and ISO, has many variations and extensions, most of which are of a proprietary nature, such as Oracle Corporation's PL/SQL or Sybase and Microsoft's Transact SQL[?]. It is also not uncommon for commercial implementations to omit support for basic features of the standard, such as the DATE or TIME data types, preferring some variant of their own. As a result in contrast to ANSI C or ANSI Fortran which can usually be ported from platform to platform without major structural changes, SQL code can rarely be ported between database systems without major modifications. Most people in the field believe that this lack of compatibility is intentional in order to force vendor lock-in in database systems.

As the name implies, SQL is designed for a specific, limited purpose -- querying data contained in a relational database. As such, it is a set-based programming language rather than a procedural language such as C or BASIC, which are designed to solve a much broader set of problems. Language extensions such as PL/SQL are designed to address this by adding procedural elements to SQL while maintaining SQL's advantages. Another approach is to allow procedural language code to be embedded in and interact with the database. For example, Oracle and others include Java in the database, while PostgreSQL allows functions to be written in Perl, Tcl, or C, among other languages.

In their SQL standard, the American National Standards Institute declared that the official pronunciation is "es queue el." However, many database professionals have taken to the "slang" pronunciation sequel,that reflects the language's original name, Sequel, before trademark conflicts caused IBM to perpetrate the current moniker.

One joke about SQL is that "SQL is neither Structured, nor a Language." This is (in part) founded on the notion that SQL isn't a Turing complete language.

Examples

Table 'X' Query Result

Y Z

1 a

2 b

Select * from X

Y Z

1 a

2 b

Y Z

1 a

2 b

Select Y from X

Y

1

2

Y Z

1 a

2 b

Select * from X where Y=1

Y Z

1 a

Given a table X, the query Select * from X will result in all the elements of all the rows of the table being shown.

With the same table, the query Select Y from X will result in the elements from the column Y of all the rows of the table being shown.

With the same table, the query Select * from X where Y=1 will result in all the elements of all the rows where the value of column Y is '1' being shown.

SQL syntax as of August 1992[?]

Database systems using SQL

assured. When you find they can be spared, order.html">order them back, or orders. "In case of failure to effect a landing, bring your co/command.html">command back instructions. You will not debark at Beaufort until so directed. "General Sheridan has been ordered to send a division of troops will be brought to fort.html">fort.html">Fort Monroe and kept there on the vessels sent to you. "U. S. GRANT, Lieutenant-General. Lieutenant-Colonel C. B. Comstock, aide-de-camp (now brevet assigned, in orders, as chief-engineer to this. It will be seen that these instructions did not differ in neither instance was there an order to assault Fort Fisher. commanding officer. The expedition sailed from Fort Monroe on the morning of the where, owing to the difficulties of the weather, it lay until destination that evening. Under cover of the fleet, the 13th, and by three o'clock P.M. was completed without loss.html">loss. On yards of Fort Fisher, and a small advance work taken possession might be made from the fort. This reconnoissance disclosed the the navy fire. In the afternoon of the 15th the fort was its entire garrison and armament. Thus was secured, by the successes of the war. Our loss was: killed, one hundred and 17th the enemy abandoned and blew up Fort Caswell and the works gave us entire control of the mouth of the Cape Fear River. At my request, Mayor-General B. F. Butler was relieved, and Virginia and North Carolina. The defence of the line of the Tennessee no longer requiring the threatening it, I determined to find other fields of operation would co-operate with other movements. General Thomas was .

On wordlookup.net

All is still licensed under the GNU FDL.
It uses material from the wikipedia.

navig stuff