Ranking in table

[Anon]

Hi,

I have problem doing ranking in table. I am not sure if it is possible, but I guess it should be. For example, I have select statement with order by clause. So I want to have in one field positions like this.

id name pos
3 Sombody 1
2 SomeNew 2
4 ssssss 3
1 aaaaaa 4

Can someone help?

[Anon]

You could use "ORDER".

SELECT * FROM TABLE ORDER BY pos