Rupesh Mishra
asked on
Please help| Getting the syntax error in below query.
select a.teamname, b.teamname from (select *, row_number() over (order by (select null)) rw from team) A
cross apply (select * from (select teamname, row_number() over (order by (select null)) rw from team) )b where b.rw > a.rw
cross apply (select * from (select teamname, row_number() over (order by (select null)) rw from team) )b where b.rw > a.rw
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
Hope it helps!