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 vote326 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote309 views1 answer
Postgres create extension if not exists
SQL
2 votes322 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote302 views1 answer
Oracle job class
SQL
1 vote318 views1 answer
Age postgres
SQL
8 votes327 views4 answers
Reset SQL auto increment
SQL
2 votes298 views1 answer
How to make insert script from table in SQL server
SQL
10 votes324 views2 answers
SQL rounding numbers
SQL
0 vote314 views1 answer
Sql output select
SQL
0 vote302 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL