ms access - Sql Statement that returns only the top 5 highest values in desc order, but the 5th en 6th value are the same? -
im struggling retrieve 5 values sql statement. want retrieve 5 highest numbers in single column. trouble of numbers repeat. when 5th , 6th highest numbers same sql statement retrieves 6 values , not 5. if 5th , 6th number same dont need 6th number sql. can please help?
here column:
number 10 9 5 5 3 3 2 1
my results are:
number 10 9 5 5 3 3
i retrieve first 5 numbers excluding 6th number.
here sql:
10 9 5 5 3 3 select top 5 number tbl order number desc
you can group them , display this:
select top 5 number tbl group number order number desc
or can use distinct
:
select distinct top 5 number tbl order number desc
Comments
Post a Comment