Re: [SQL] Order by in Select

2000-07-19 Thread Stephan Szabo
> What can I add to the above sql statement so that is fetches the > specified id first in a sorted list? > > eg: if $specified_id=5; > I want: 5,5,5,1,2,3,3,4,4,4,6,6,7 > > I could have done it in two different sql statements where one fetches > specified_id and the other fetches and sorts othe

[SQL] Order by in Select

2000-07-19 Thread Bernie Huang
Hello, I have a list of id's that I need to sort and fetch. eg; 1,3,6,5,4,3,4,5,6,7,5,4,2 Select id >From table Order By id Asc; it becomes like: 1,2,3,3,4,4,4,5,5,5,6,6,7 What can I add to the above sql statement so that is fetches the specified id first in a sorted list? eg: if $specified_