Increase the Power of SQL? (1)

Can Your Database Increase the Power of SQL?

SQL has been enormously successful as a database interface language, but its lack of consistency is well known. SQL is not an orthogonal lanaguage. Capabilities available in one context are not in others. Common queries require inconvenient and poor performing work-arounds to accomplish.

FirstSQL fully supports ANSI syntax and provides ODBC extensions. In addition, FirstSQL provides innovative extensions to standard SQL that greatly increase the power of SQL in manipulating data.

This section examines FirstSQL extensions to standard SQL. Many of the How do I do this in SQL? questions found on electronic forums can be resolved using the extended features of FirstSQL. Does your database truly increase the power of SQL with useful extensions? Compare your database's capabilities with those described in this section.

View Capabilities in Queries, FirstSQL allows full queries embedded in the FROM clause, providing view capabilities directly in a SQL query.
General Use of Single Valued Subqueries, FirstSQL allows a subquery producing a single value to be used any place a scalar value can.
Other FirstSQL Extensions, FirstSQL provides a number of additional extensions that also expand the power of SQL.

Return to Can your Database do this? Return to FirstSQL Home Page

Can Your Database Increase the Power of SQL?

Contents: