[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Order by

Totally... something like

select 'SA', ...
from
where

union all

select 'SE', ...
from
where

Order by 1, 2, 3, 4

-----Original Message-----
From: sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org
[mailto:sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org] On Behalf
Of EricRection@aol.com
Sent: Friday, August 27, 2004 3:07 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Order by

ORDERing by variables sounds a bit dodgy.

How about you have a UNION query with one part WHERE SAL>30000 with a
constant of SA and one part for WHERE SAL<=30000 with a constant of SE, and
then order by the contant?

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users