FreeLists / oracle-l / RE: SQL Comparison Site

["Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>]

I am still puzzle by the arguments of Oracle to refuse the
implementation of the 'LIMIT' clause. It is natural clause of daily
usage.

 

Select * from table group by 1 order by 1,2 limit 5.    # to display
only 5 rows

 

So simple. Instead with Oracle you must use inline view or some kind of
those unnatural analytical clauses.

SQL was created as natural language. I may say in my daily discussion
something like:

 

'I selected some from a list of provider, limited to the five best'

 

I am not saying

 

'I selected, rank() over  the best 5, from a list of provider'

 

How do you pronounce the '()' in natural language?

 

Bernard Polarski

  _____  

From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: donderdag 1 februari 2007 2:29
To: Oracle-L Freelists
Subject: SQL Comparison Site

 


I "stumbled" across an interesting site today.

It endeavors to compare various implementations of SQL.

It appears to be a work in progress, so maybe some here
may offer contributions.

In any case, it appears quite useful.

http://troels.arvin.dk/db/rdbms/


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist