Select the 100 lowest values in SQL?

Question

I've been looking around for a while, and it seems it cant be found anywhere. I want to know how do you select the 100 highest and the 100 lowst values in a column? The MIN-function only chooses the lowest one and the MAX the highest one.

Anyone out there who knows how you do this?

Answer 1

SQL Server

• Top 100 Highest

  SELECT TOP 100 * FROM MyTable
  ORDER BY MyCol DESC
  

• Top 100 Lowest

  SELECT TOP 100 * FROM MyTable
  ORDER BY MyCol ASC
  

MySQL

• Top 100 Highest

  SELECT * FROM MyTable
  ORDER BY MyCol DESC LIMIT 100
  

• Top 100 Lowest

  SELECT * FROM MyTable
  ORDER BY MyCol ASC  LIMIT 100
  

Answer 2

You can do it as below,

Highest

select * from
tablename
order by
column DESC
limit 0,100

Lowest

select * from
tablename
order by
column ASC
limit 0,100

EDIT

For SQL Server replace select * from with select TOP 100 * from

The SELECT TOP clause is used to specify the number of records to return.

Answer 3

Use sorting in ascending and descending order and limit output to 100

Answer 4

if you use Sql server you can order query desc and select top 1000 like :

select top(1000) * from mytable order by value desc