How to generate row number in SQL Without ROWNUM

Technology Community › Category: SQL › How to generate row number in SQL Without ROWNUM

VietMX Staff asked 3 years ago

Consider:

SELECT name, sal, (SELECT COUNT(*)  FROM EMPLOYEE i WHERE o.name >= i.name) row_num
		FROM EMPLOYEE o 
		order by row_num

Question Tags: Senior Level, SQL