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

13 votes142 views2 answers
Oracle select into and inner join
SQL
1 vote144 views1 answer
Md5 encryption for existing records
SQL
1 vote144 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote144 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote144 views1 answer
Spark sql grows beyond 64 kb
SQL
2 votes134 views1 answer
Scaffold npgsql net core
SQL
7 votes172 views4 answers
Mysql delete older duplicates
SQL
0 vote146 views1 answer
Stored function in sql
SQL
2 votes292 views1 answer
Set auto increment from 1
SQL
2 votes224 views1 answer
Oracle list grants on package
SQL