Re: SQL and Order By Question

[Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>]

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