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

11 votes340 views2 answers
Import mysql dump command line windows
SQL
0 vote250 views1 answer
Alter column to not null with default value sql server
SQL
7 votes203 views1 answer
Mysql remote connection command line
SQL
0 vote225 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote193 views1 answer
Postgres call view
SQL
0 vote198 views1 answer
Ms Sql set us timezone
SQL
33 votes186 views2 answers
Postgres how to add field created at
SQL
13 votes229 views3 answers
List all the tables in sql
SQL
2 votes222 views1 answer
Sql server current date minus 5 years
SQL
0 vote214 views1 answer
Compare field sql server
SQL