i used this query to generate an ascending counting from 1 to no of records but when i use order by i can't do that could any one help,
this is the query an d it works will:

select (select count(e1.firstname) from employees as e1 where e1.EmployeeID<=e2.EmployeeID),e2.firstname from employees as e2

but when adding order by like follows
select (select count(e1.firstname) from employees as e1 where e1.EmployeeID<=e2.EmployeeID),e2.firstname from employees as e2order by e2.firstname

any have a comment

Ahmed Ali
Software Developer

__________________
Ahmed Ali
Senior Software Developer