Use top with join

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 left,right ,inner  join as per your requirment....

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