Returning smalest values in a query

[mtl77]

How do you get the smallest 10 values from a list of 20 in an SQL 200 query

 

[rajeevnandanmishra]

Hi

Try this:

SELECT TOP 10 DISTINCT myColumn FROM myTable ORDER BY myColumn

---
Raj

 

[mtl77]

Hi Raj,

Thanks for the help. The exact syntax is

SELECT DISTINCT TOP 10 myColumn FROM myTable ORDER BY myColumn

Cheers

 

[rajeevnandanmishra]

Thanks mtl77,

i am not old here. So, just missed the syntax.

Thanks again for correcting it.


---
Raj

 

[mtl77]

I just realized that the syntax will not work with what i'm using it for. I need the ten lowest numbers with duplication allowed, and distinct does not allow that.

Any thoughts?

 

[jackfl]

SELECT TOP 10 myColumn FROM myTable ORDER BY myColumn DESC

 

[rajeevnandanmishra]

Hi mtl77,

The query of jackfl give you the required results after you modify a little bit. That is just remove the DESC from the query and it will work.


---
Raj

 

[mtl77]

That works Perfectly, thanks for the help Raj and Jackfl.

 

[SQLBill]

By the way, you can use the WITH TIES as part of the TOP N. Here's what it does:

DATA:

1
2
2
3

using TOP 3 returns:
1
2
2

using TOP 3 WITH TIES returns:
1
2
2
3

-SQLBill