Re: SQL and Order By Question

You really shouldn't do this, or the case statement as suggested by someone
else. Cuz now you're locked into hardcoding. If you cannot use another
field, then you should look into the custom sort as suggested by others.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


java400-l-bounces@xxxxxxxxxxxx wrote on 07/30/2007 11:45:49 AM:

Hi
I cannot modify the table, can i add this field 2 on
fly to the SQL statment
i have SQL statement like below
select * from table where Field1 = 'a' or Field1'='c'
or Field1='d' or Field1='b'
So if i can add row number or get the query without
any sort or order by, then would be a great help

Ashish
--- Michael_Schutte@xxxxxxxxxxxx wrote:

Well, if you don't want to order by a,b,c,d... then
you are going to need
a different field to sort on that will put it in the
order you want.

Field1 Field2
a 1
b 4
c 2
d 3


select field1 from file order by field2


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q
Pulled Pork Knife & Fork
Sandwich!"

java400-l-bounces+michael_schutte=bobevans.com@xxxxxxxxxxxx

wrote on
07/30/2007 11:12:02 AM:

Hi
I have a table, which i want to sort by value in

Key,

for example the table is as below
Key Desc
a This is A
b This is B
c This is C
d This is d

I want to read the result set as

a
c
d
b

How do i write this SQl statement, if i just do

order

by Key i can get it either a,b,c,d or d,c,b,a but

not

the way i want
Any ideas

Ashish

A$HI$H