sql cross apply vs join

Solutions on MaxInterview for sql cross apply vs join by the best coders in the world

showing results for - "sql cross apply vs join"

1SELECT M.ID,M.NAME,D.PERIOD,D.QTY
2FROM MASTER M
3INNER JOIN
4(
5    SELECT TOP 2 ID, PERIOD,QTY 
6    FROM DETAILS D      
7    ORDER BY CAST(PERIOD AS DATE)DESC
8)D
9ON M.ID=D.ID
10

similar questions

syntax for cross join in mysql correlated subqueries in microsoft sql server inner join vs outer join sql right join oracle sql union tables with different columns sql select from multiple tables without join sql left outer join vs left join cross schema query oracle 2 users sql left join multiple tables with conditions bidirectional outer join sql right join sql sql cross join join vs inner join right outer vs left outer join joins vs includes right outer join in linq sql

queries leading to this page

sql server cross apply vs inner join sql join and cross apply in same query sql cross apply vs join cross join vs cross apply sql cross apply cross join cross apply join in sql cross apply vs cross join in sql server cross apply vs inner join cross join vs cross apply sql server cross apply vs cross join cross apply vs join sql server cross join vs cross apply cross apply sql join sql cross apply vs join