Get Data using Joins in sqlserver

@Nanda,

   appId and versionId  both are in different tables. then, what is unique column for both tables. you must show the table structure or column fields, then only we can give the query.

WITH QResult

AS (SELECT

ROW_NUMBER() OVER (

PARTITION BY RD.appid ORDER BY SecondndTable.versionId DESC

) AS Row

,RD.appid

,SecondndTable.versionId

FROM YourTableName AS RD

INNER JOIN SecondndTable ON RD.appid=SecondndTable.appid

)

SELECT

appid

,versionId

FROM QResult

WHERE row = 1

 

you said "here appid and version id both are in different tables."

then you need to post the table structure for someone to help you write the query

 

I can suggest you following without looking at your table structure:

add the following where condition in your query:

 

where versionId = (select max(versionId) from VersionTable where VersionTable.appId = appid_from_main_query)