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

6 votes326 views2 answers
Sql display max value
SQL
0 vote315 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote346 views1 answer
How to define a non primary composite key in sql
SQL
0 vote337 views4 answers
Mysql count table rows
SQL
2 votes403 views1 answer
Tcl in sql
SQL
0 vote321 views1 answer
Mysql procedure between two tables
SQL
0 vote372 views1 answer
Add new column in sql with foreign key
SQL
0 vote323 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote351 views1 answer
Mssql disable foreign key constraint
SQL
1 vote359 views1 answer
Sql how to replace full stop
SQL