In MariaDB how do I select the top 10 rows from a table?

Question

I just read online that MariaDB (which SQLZoo uses), is based on MySQL. So I thought that I can use ROW_NUMBER() function

SELECT * FROM ( 
  SELECT  * FROM route
) TEST7
WHERE ROW_NUMBER()  < 10

then I get this error :

Error: FUNCTION gisq.ROW_NUMBER does not exist

possible duplicate of [ROW\_NUMBER() in MySQL](http://stackoverflow.com/questions/1895110/row-number-in-mysql) — tadman, Nov 25 '14 at 17:49
The [MySQL 5.6 documentation](http://dev.mysql.com/doc/refman/5.6/en/) is pretty thorough and has a function index. It's something any developer should have bookmarked and at the ready. If you're ever curious if a function exists, look there first. Stack Overflow is a good second place to check when you're stumped. — tadman, Nov 25 '14 at 17:54

score 34 · Accepted Answer · answered Nov 25 '14 at 17:55

34

You can use the limit clause:

SELECT * FROM route LIMIT 10

This can, of course, be used on a sorted query too:

SELECT * FROM route ORDER BY some_field LIMIT 10

answered Nov 25 '14 at 17:55

Mureinik

4

In fact, there's almost no point in it not being on a sorted query! – Strawberry Nov 25 '14 at 18:04

declension · Answer 2 · 2015-04-28T11:21:08.150

2

use LIMIT 10 at the end of your statement.

edited Apr 28 '15 at 11:21

answered Nov 25 '14 at 17:55

declension

2 Answers2