Skip to content
Advertisement

SQL query to get top 1 (most recently updated)

I have two tables apps and builds

apps

builds

One app can have multiple builds, but I want to return only most recently updated row of builds.

This query is not returning anything.

Advertisement

Answer

Use CROSS APPLY:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement