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

1 vote125 views1 answer
Sqlalchemy order_by
SQL
5 votes131 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote113 views1 answer
Copy Table from SQL to CSV
SQL
1 vote122 views1 answer
SQL query to get all table records count from a database
SQL
0 vote138 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
2 votes78 views5 answers
Alter table primary key postgresql
SQL
0 vote72 views1 answer
Sql truncate table referencing itself
SQL
0 vote101 views1 answer
Knex last insert id mysql
SQL
0 vote134 views1 answer
Sql injection payload list github
SQL
0 vote137 views2 answers
How to list all values of a column that start with a letter in sql
SQL