Sql cross apply vs join

SELECT M.ID,M.NAME,D.PERIOD,D.QTY
FROM MASTER M
INNER JOIN
(
    SELECT TOP 2 ID, PERIOD,QTY 
    FROM DETAILS D      
    ORDER BY CAST(PERIOD AS DATE)DESC
)D
ON M.ID=D.ID

Source: stackoverflow.com

Similar codes

1 vote137 views1 answer
Postgres left join
SQL
0 vote117 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote127 views2 answers
How to know the character set of an oracle databes
SQL
0 vote145 views1 answer
Except in sql
SQL
1 vote118 views1 answer
How to test for sql injection
SQL
0 vote159 views1 answer
Mysql error codeigniter
SQL
0 vote211 views1 answer
Mysql select field if condition
SQL
2 votes141 views1 answer
Oracle trace file
SQL
5 votes149 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote120 views1 answer
Sequelize postgresql schema
SQL