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

0 vote367 views1 answer
Postgresql stored procedure update table values
SQL
12 votes381 views6 answers
Distinct in sql server
SQL
10 votes339 views1 answer
Oracle object dependencies
SQL
1 vote353 views3 answers
Rows, INSERT INTO
SQL
0 vote334 views1 answer
Mysql sql select one day before
SQL
11 votes340 views1 answer
Mysql order by two columns priority
SQL
1 vote364 views1 answer
Sql set auto increment back to 0
SQL
1 vote335 views1 answer
Pagination sql
SQL
-2 votes339 views1 answer
Group functions in sql
SQL
7 votes344 views1 answer
Oracle reset sequence
SQL