Returning a unique set of values from a table

Question

Hi All.

I have a table log as per below.

What I will like to do is return the last 3 release no's ordering by the release data.

In the case of the example below, that would be 77,66 and 55

The query below is not correct.

select releaseno  
from  
(select distinct releaseno, releasedate  
from release_log  
order by releasedate desc) last_3_release_no_extract  
  

Answer 1

Try this query too:

select top(3) releaseno, max(releasedate) as releasedate
from release_log
group by releaseno
order by releasedate desc

Answer 2

;With cte As
(Select releaseno, 
  Dense_Rank() Over(Order By releaseno Desc) As rk
From release_log)
Select releaseno
From cte
Where rk <= 3;

Tom