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

Popular posts from this blog

basic authentication with http post params android -

vb.net - Virtual Keyboard commands -

css - Firefox for ubuntu renders wrong colors -