[sreeraj]

Hi Folks,

Back again with a new problem....
My Problem is

I have a simple select query
The query contains the same field being selected twice and without any aliases.Now when i try to order the query by this field oracel gifts me an ambiguity error.

Ex
select filed1,field2,field3,.......,field1 from tablemine
order by field 1.

any way to refernce the field without using and alias.

Thanx in advance
Regs

[andrewst]

Well, why not use an alias? But anyway, you can refer to columns by position in the ORDER BY clause:

select filed1,field2,field3,.......,field1 from tablemine
order by 1;

[sreeraj]

Hi,

Thanx Buddy...
thats exactly what i wanted

Regs