Skip to content
Advertisement

Show Unique values only

I am using SQL Server 2019 and looking for a way to show ONLY the latest value for each AOC based on its latest FW_Version. Here is my query I have so far but this shows everything:

What I would like to show ONLY items marked in yellow… How can I make this happen? enter image description here

Here is the list of my Tables which are joined based on their corresponding ID’s

Table 1: Model

Table 2: FormFactor

Table 3: ProductRelease

Table 4: Intel

Table 5: Chipset

Advertisement

Answer

One method uses window functions:

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