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 vote277 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote255 views1 answer
Sql server udf performance
SQL
5 votes286 views4 answers
Traduction
SQL
0 vote268 views1 answer
Template MySQL Zabbix agent
SQL
1 vote253 views1 answer
T-SQL Alter the column data type
SQL
0 vote285 views1 answer
Oracle sql all days except weekends
SQL
7 votes301 views2 answers
Sql remove duplicates based on column
SQL
0 vote267 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote252 views1 answer
Grant access on table in oracle
SQL
2 votes261 views1 answer
Sql count having
SQL