MySQL SELECT with LIMIT

Easy 20 pts New · no attempts yet sql

Topics

Toolliyo edge

Select top 2 highest salaries using LIMIT.

Static hints

ORDER BY salary DESC LIMIT 2

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

-- MySQL schema
CREATE TABLE employees (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), dept_id INT, salary DECIMAL(10,2));
CREATE TABLE departments (id INT PRIMARY KEY, name VARCHAR(50));
INSERT INTO employees (name, dept_id, salary) VALUES ('Ali',1,90000),('Sara',2,120000);
INSERT INTO departments VALUES (1,'Engineering'),(2,'Sales');
SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 2;

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

MySQL uses LIMIT for pagination—PostgreSQL uses LIMIT too; SQL Server uses TOP.

Next All problems

MySQL SELECT with LIMIT

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion