# MySQL SELECT - again

**URL:** <https://forum.kirupa.com/t/mysql-select-again/46362>\
**Category:** Uncategorized\
**Created:** [March 23, 2004, 8:07pm UTC](https://forum.kirupa.com/t/mysql-select-again/46362 "2004-03-23T20:07:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![T\_O](https://avatars.discourse-cdn.com/v4/letter/t/cc9497/32.png) [@T\_O](https://forum.kirupa.com/u/T_O)\
**Post date:** [March 23, 2004, 8:07pm UTC](https://forum.kirupa.com/t/mysql-select-again/46362/1 "2004-03-23T20:07:32Z")

</div>

ok, I have this table

```auto

id points
1 123
2 321
3 2 
4 1
5 3
6 1233
7 51233
8 123
9 855
10 21
11 12
12 89
13 65
14 21
15 23

```

I want to list the top 5.

```php

$resultaat=mysql_query("SELECT * FROM table ORDER BY points LIMIT 0,5");

```

it list…

```auto
1
12
123
123
1233

```

but i want to list for the highest number for 5 later…  
thus,

```auto
51233
1233
855
321
123

```

How can i do that… with SELECT.