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

16 votes167 views1 answer
Sqlserver add column to table
SQL
0 vote179 views1 answer
Select place default lat long
SQL
8 votes180 views2 answers
Safe update mode in mysql
SQL
0 vote170 views1 answer
Pgsql is not permitted to log in
SQL
3 votes232 views2 answers
Oracle drop column
SQL
1 vote186 views2 answers
Logical operators in sql
SQL
0 vote174 views1 answer
Xampp increame mysql speed
SQL
3 votes223 views1 answer
Sql several or
SQL
0 vote238 views2 answers
How to take recent row without limit in mysql
SQL
0 vote196 views1 answer
How to see the query of a view in mysql
SQL