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 vote102 views1 answer
Firebase sql
SQL
4 votes144 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote110 views1 answer
How to add timestamp column in mysql
SQL
2 votes118 views4 answers
Sql query interview questions
SQL
0 vote120 views3 answers
Mysqli count down
SQL
0 vote105 views1 answer
Mysql default timestamp value to be current timestamp
SQL
3 votes100 views2 answers
To_char oracle
SQL
2 votes135 views1 answer
Search query in mysql
SQL
0 vote107 views1 answer
Mysql select row with min date
SQL
2 votes103 views1 answer
Drop table if exists in postgres
SQL