Re: Multivariate relation (Was topological databases)
From: Tegiri Nenashi <TegiriNenashi_at_gmail.com>
Date: Fri, 30 Jan 2015 09:29:15 -0800 (PST)
Message-ID: <26cba1f5-863d-4e01-b7fc-708f5afa3d0a_at_googlegroups.com>
Date: Fri, 30 Jan 2015 09:29:15 -0800 (PST)
Message-ID: <26cba1f5-863d-4e01-b7fc-708f5afa3d0a_at_googlegroups.com>
On Thursday, January 29, 2015 at 8:13:16 PM UTC-8, Derek Asirvadem wrote:
> > because "order by" clause allows arbitrary expressions,
>
> No it doesn't. As per the syntax above, it allows either a /column_name/ or a /column_no/ (where 0 < /column_no/ ≤ /no_of_columns/
"order by emp_no+1" works in Oracle and MySql, the two the most ubiquitous databases on the planet. I honestly don't understand why are you reluctant to allow users to sort their result by salary+bonus. Finally, SQL is the verbose champion of programming languages, what difference couple of saved keystrokes at the end of the query does it make? Received on Fri Jan 30 2015 - 18:29:15 CET