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








As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.