Re: SQL and Order By Question

Hi
The values for key are going to be hard coded in the
application,
Also i am not sure if i can a custom sort from JDBC
call, i have a process which calls bunch of SQL
statment and just builds a XML file from it.
so i wrote this query and it works
select Field1, Field2,
case
when Field1 = 'a' then '1'
when Field1 = 'c' then '2'
when Field2='d' then '3'
when Field1 ='b' then '4'
end mysort
from table
where Field1 ='a' or Field1='b' or Field1='c' or
Field1='d'
order by mysort

This SQL statements returns me the result set in the
sort i want
Thanks for the suggestion

Ashish
--- Michael_Schutte@xxxxxxxxxxxx wrote:

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