SQLTeam.com | Weblogs | Forums

Select query

Hi.

A little help modifying select query to bring back first record only, i don't need to see all variations of the primary key which is NBN_Location_Id

SELECT dbo.NTT_Tracked_Path_Report.NBN_Location_Id, dbo.NTT_Tracked_Path_Report.ADBoR_Id, dbo.NTT_Tracked_Path_Report.ADBoR_Textual_Address
FROM dbo.NTT_Tracked_Path_Report
LEFT JOIN dbo.Book2 ON dbo.NTT_Tracked_Path_Report.NBN_Location_Id = dbo.Book2.NBN_Location_Id

hi please try TOP 1

select TOP 1 * from table