sql - SELECT TOP 2 * table ORDER BY country -

sql - SELECT TOP 2 * table ORDER BY country -

why getting more 2 results, when utilize statement?

select top 2 * customers order country desc

you can seek here: http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_top&ss=-1

if using mysql, you're not using proper syntax. don't utilize top... that's sql server (and other "microsoftish" dialects ;-) ). must utilize limit:

select * customers order country desc limit 2

sql sql-order-by