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

3 votes127 views2 answers
Oracle sql truncate table
SQL
3 votes128 views1 answer
Sql multiple column index
SQL
5 votes155 views2 answers
Get columns number sql
SQL
22 votes131 views4 answers
Show list of users in mysql
SQL
0 vote131 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote148 views1 answer
Get last updated row sql server
SQL
12 votes127 views2 answers
Delete all nodes neo4j
SQL
1 vote107 views1 answer
Strict in postgres SQL
SQL
0 vote146 views4 answers
Open mysql port bitnami tomact
SQL
0 vote147 views1 answer
Drop table BigQuery table columns
SQL