Mime-Version: |
1.0 (Apple Message framework v753) |
Content-Type: |
text/plain; charset=US-ASCII; delsp=yes; format=flowed |
Date: |
Sun, 17 Feb 2008 08:42:56 -0500 |
Reply-To: |
|
Subject: |
|
From: |
|
In-Reply-To: |
|
Content-Transfer-Encoding: |
7bit |
Sender: |
|
Parts/Attachments: |
|
|
On Feb 16, 2008, at 7:50 PM, Christopher Green wrote:
> One of the things AS spoiled me with from early on is
> "whose clauses" (apparently also known as the by-test
> reference form). My question is, for those of you who
> reeeeally know other scripting/programming languages,
> what other languages have this funcionality as a basic
> feature??
>
> Anyone?
The "WHERE" clause in SQL is essentially the same thing.
SELECT lastname FROM users WHERE firstname LIKE 'Chris%'
This means roughly the same thing as...
get the lastname of every user whose firstname begins with 'Chris'
But the thing I love about SQL is that it omits articles and copulae.
I call it a Tonto language, because most statements come out sounding
like that character's speech in the Lone Ranger radio and TV series.
Tarzan language would be equally applicable.
SQL also has a "HAVING" clause for restricting grouped data.
SELECT a, sum(b) FROM thistable GROUP BY a HAVING a < 100
|
|
|