Experiment with sorting after query limit

Question

So this is my first question here, please forgive me if something is wrong.

I am trying to make a sort query based on constraints.

So there is a Customers table with 90 records.

I want to first perform a query limited to 3 records, and then sort the query results by a column called ContactName.

I think this might be a nested query. Nested queries run fine in SQL Server, but don't know how to implement it in MySQL.

Limit query:

Select * from customers limit 3;

Sort after limiting the query (my guess, but this doesn't work):

Select * from (Select * from customers limit 3) Order by ContactName;

Please help. Thanks.

Answer 1

You only need this

Select * from customers Order by ContactName limit 3;