Ann K
asked on
select over clause
What is the use of over in select
SELECT ROW_NUMBER() OVER(ORDER BY emp_id) AS 'Row Number', * from dbo.employee
ORDER BY SSN
SELECT ROW_NUMBER() OVER(ORDER BY emp_id) AS 'Row Number', * from dbo.employee
ORDER BY SSN
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.