How to do an inner join on row number in sql server

by

try this:

USE ROW_NUMBER() function in sql server 2008

select A.val,B.val 
from(
    SELECT val,row_number() over (order by val) as row_num
    FROM A)A
join
    (SELECT val,row_number() over (order by val) as row_num
    FROM B)B
on  A.row_num=B.row_num
ORDER BY A.val,B.val

SQL fiddle demo

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. How can I select the first day of a month in SQL?
  5. Multi-statement Table Valued Function vs Inline Table Valued Function
  6. SQL Server Insert if not exists
  7. Select statement to find duplicates on certain fields
  8. How to set table name in dynamic SQL query?
  9. Using a Variable in OPENROWSET Query
  10. How to find current transaction level?
  11. How do I see active SQL Server connections?
  12. EXISTS vs JOIN and use of EXISTS clause
  13. Check for file exists or not in sql server?
  14. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  15. Group DateTime into 5,15,30 and 60 minute intervals
  16. Why is a UDF so much slower than a subquery?
  17. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. Alternate of lead lag function in SQL Server 2008
  20. How do I edit a table in order to enable CASCADE DELETE?
  21. UNIX_TIMESTAMP in SQL Server
  22. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  23. SQL Server SELECT LAST N Rows
  24. How can I group by date time column without taking time into consideration
  25. The transaction log for the database is full
  26. Generate random int value from 3 to 6
  27. Add emoji / emoticon to SQL Server table
  28. Cumulative Total in MS Sql server [duplicate]
  29. Script entire database SQL-Server
  30. Editing Record issues in Access / SQL (Write Conflict)

Leave a Comment