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 votes273 views2 answers
Oracle undotbs usage
SQL
1 vote235 views1 answer
Quit mysql
SQL
0 vote228 views1 answer
MySQL get all previous date record
SQL
16 votes232 views1 answer
Mysql reset auto increment value
SQL
0 vote239 views1 answer
Mysql insert into select transaction c#
SQL
3 votes211 views1 answer
Two selects in one query
SQL
0 vote274 views2 answers
How to check if a column exists in a SQL Server table?
SQL
5 votes219 views3 answers
Select tables from mysql database
SQL
0 vote224 views1 answer
Mysql set variable to today's date
SQL
0 vote239 views1 answer
Sql find gaps in date ranges
SQL