The Power of SQL



next up previous
Next: Modifying the Database Up: SQL Previous: Aggregate Functions

The Power of SQL

  1. SQL is as powerful in expressiveness as the relational algebra.

    Strictly speaking, it is more powerful than relational algebra, as it includes aggregate functions, ordering of tuples, etc.

  2. SQL is not as powerful as a general-purpose programming language. There are queries that cannot be expressed in SQL, but can be programmed in C, Fortran, Pascal, Cobol, etc.



Page created and maintained by Osmar R. Zaï ane
Last Update: Mon Oct 16 16:41:58 PDT 1995