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

2 votes306 views1 answer
Rails execute sql
SQL
0 vote292 views2 answers
Drop tables from local table database postgres
SQL
0 vote276 views1 answer
Drop unique
SQL
10 votes281 views5 answers
Mysql create user
SQL
0 vote296 views1 answer
C# execute transact sql
SQL
0 vote303 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote289 views1 answer
Sql cnvert bit to nvarchar
SQL
1 vote272 views1 answer
Convert rows to string sql server
SQL
0 vote277 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote295 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL