EXPLAIN EXTENDED

How to create fast database queries

5 Claims About SQL, Explained

with 2 comments

1. Is SQL is a declarative language?

First of all, let's define the terms.

A declarative language describes the result, not the process to achieve it. In a declarative language you tell "what do I need".

A procedural language describes control flow: exact steps the machine needs to perform in order to achieve this result. In a procedural language you tell "what do you do".

SQL, as it was originally designed, is a declarative language.

2980020699_0dfbe889f7_o

For instance you need to know how many customers above 40 live in each city. You issue a query like:

Read the rest of this entry on tech.pro ยป

Written by Quassnoi

October 28th, 2013 at 11:00 pm

Posted in Miscellaneous

2 Responses to '5 Claims About SQL, Explained'

Subscribe to comments with RSS

  1. Tech.Pro site link is not working and couldn’t access the article

    Manoj

    15 Sep 15 at 19:06

  2. @Manoj: seems they’re out of business

    Quassnoi

    15 Sep 15 at 19:12

Leave a Reply