Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

- reference, sql

## Correlation names and Column name qualifiers in correlated references

A correlation name can be defined in the from clause of a query and in the first clause of an update or delete statement. for example, the clause FROM X.MYTABLE Z establishes Z as a correlation name for X.MYTABLE. With…

- admin
- December 17, 2009

- reference, sql

## How to find out datbase version using SQL query

DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;

- admin
- December 10, 2009

- reference, sql

## SQL Language elements (characters)

characters, the basic symbols of keywords and operators in SQL language are the single-byte characters that are part of all IBM character sets. charaters of language are classified as letters, digits or special characters. A letter is any of the…

- James
- December 6, 2009