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 vote283 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote286 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote299 views1 answer
Alter check command
SQL
1 vote296 views1 answer
Mysql current time
SQL
9 votes283 views1 answer
Oracle get table schema
SQL
0 vote293 views1 answer
Oracle current timestamp
SQL
0 vote319 views1 answer
Sql with example
SQL
0 vote266 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote305 views1 answer
Mysql cli output to a file
SQL
0 vote316 views1 answer
How do I insert a blob in SQL?
SQL