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

4 votes278 views2 answers
Oracle drop job
SQL
5 votes264 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote284 views1 answer
Make parameters nullable in sql server
SQL
0 vote263 views1 answer
Why we have to set the password for my sql server
SQL
0 vote280 views1 answer
Plsql check how much space all databases are consuming
SQL
13 votes206 views2 answers
Oracle all source
SQL
0 vote285 views1 answer
Command line mysql xampp
SQL
0 vote268 views1 answer
Create a sql server database programmatically
SQL
0 vote241 views1 answer
Raiserror nowait sql server
SQL
0 vote285 views1 answer
Create synonym for dblink in oracle
SQL