On this I second Lefteris. The syntax used in this example is by the way a beautiful example of how stupid SQL syntax can get, with or without PERCENT.
SELECT TOP 25 [ PERCENT ] book_name, cost, date FROM book_information ORDER BY cost DESC; This is non-sense. ORDER BY is defined as a result *presentation* clause, and here (and in many othre dialects) it is overloaded with a result definition role. What then if I want the 25 most expensive books, but ordered by date? On Thu, Sep 22, 2011 at 18:13, Fabian Groffen <[email protected]> wrote: > On 22-09-2011 16:58:12 +0200, Lefteris wrote: > > just because microsoft does it for another operator does not mean that it > is > > the correct intuitive way to do it. > > http://sql-plsql.blogspot.com/2010/05/sql-top.html > > _______________________________________________ > Checkin-list mailing list > [email protected] > http://mail.monetdb.org/mailman/listinfo/checkin-list > >
_______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
