Re: Distinct in query results in wrong order by
From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 19 Jun 2003 15:32:35 -0500
Message-ID: <0d74fvoc5r4lmv7ru2pp7vc0k19138nktg_at_4ax.com>
1 select office_nm from hr_public
2 where rownum < 12
3* order by empl_nm
SQL> / OFFICE_NM
Metro District
Finance
Information Technology
Freight and Commercial Vehicle Op's.
Bridge
Metro District
Audit
Land Management
EEO & Contract Management
Communications
Land Management
sal_phipps_at_hotmail.com (Sal) wrote:
Date: Thu, 19 Jun 2003 15:32:35 -0500
Message-ID: <0d74fvoc5r4lmv7ru2pp7vc0k19138nktg_at_4ax.com>
Actually Oracle does as well...Sometimes we make the solution harder than it needs to be.
1 select office_nm from hr_public
2 where rownum < 12
3* order by empl_nm
SQL> / OFFICE_NM
Metro District
Finance
Information Technology
Freight and Commercial Vehicle Op's.
Bridge
Metro District
Audit
Land Management
EEO & Contract Management
Communications
Land Management
11 rows selected.
SQL>
sal_phipps_at_hotmail.com (Sal) wrote:
>Competitor DBMS products allow you to sort by any column to like,
>whether in the select list or not.
>
>
>Sal
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu Jun 19 2003 - 22:32:35 CEST