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 vote163 views1 answer
Hour differeence in mysql
SQL
0 vote134 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
31 votes173 views4 answers
Mysql grant execute
SQL
1 vote144 views2 answers
Sql left characters
SQL
0 vote146 views2 answers
List all constraints in postgres
SQL
0 vote156 views1 answer
Oracle chain step succeeded
SQL
4 votes144 views3 answers
Sqlite show columns
SQL
0 vote139 views1 answer
Show create table in postgresql
SQL
0 vote123 views1 answer
Sql examples from your work
SQL
0 vote139 views1 answer
T-sql conditional order by multiple columns
SQL