Use top with join

Question

Hi how to use top with join in sqlserver ?

Pankaj Kumar Choudhary · Answer

Hello @Davin you can see this code select top(1) student.sname  Marks.marks from student left outer join Marks on student.sid=Marks.sid here i use the top command with join you can use any type of join like leftright inner join as per your requirment....

Nanhe Siddique · Answer

hi davin Select top 1 a.* from table1 a table2 b where a.idcolumn=b.idcolumn order by the relavant_column this is sample code to using top clause in sql

Gowtham Rajamanickam · Answer

http://stackoverflow.com/questions/2033699/top-1-with-a-left-join

Gowtham Rajamanickam · Answer

http://stackoverflow.com/questions/2043259/sql-server-how-to-join-to-first-row