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 vote177 views1 answer
Oracle explain plan
SQL
32 votes192 views6 answers
How to change column name in sql
SQL
7 votes184 views1 answer
Buy forge mods server hosting
SQL
0 vote183 views1 answer
Run sql script file and changes db name in this file using c#
SQL
3 votes182 views1 answer
Create a table with an id in mysql
SQL
0 vote176 views1 answer
Add multiple field in table sql
SQL
24 votes195 views4 answers
Mysql datetime
SQL
-1 vote196 views1 answer
Ms sql select datetime as date
SQL
9 votes181 views4 answers
Add primary key to existing table sql
SQL
0 vote219 views1 answer
Sql convert unix time to date
SQL