Рет қаралды 521
Learn how to use the SQL LIMIT clause to control the number of rows returned in your queries. Improve query performance and manage large result sets effectively.
#sql #sqlforbeginners
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
salary DECIMAL(10, 2)
);
INSERT INTO employees (employee_id, first_name, last_name, salary) VALUES
(1, 'John', 'Doe', 50000.00),
(2, 'Jane', 'Smith', 60000.00),
(3, 'Michael', 'Johnson', 55000.00),
(4, 'Emily', 'Williams', 58000.00),
(5, 'Robert', 'Brown', 62000.00),
(6, 'Ava', 'Jones', 51000.00),
(7, 'William', 'Davis', 54000.00),
(8, 'Sophia', 'Miller', 57000.00),
(9, 'James', 'Wilson', 52000.00),
(10, 'Olivia', 'Taylor', 59000.00),
(11, 'Benjamin', 'Anderson', 61000.00),
(12, 'Isabella', 'Thomas', 53000.00),
(13, 'Ethan', 'Martinez', 60000.00),
(14, 'Mia', 'Jackson', 54000.00),
(15, 'Alexander', 'White', 58000.00),
(16, 'Avery', 'Harris', 56000.00),
(17, 'Daniel', 'Martin', 52000.00),
(18, 'Sofia', 'Thompson', 61000.00),
(19, 'Matthew', 'Garcia', 55000.00),
(20, 'Charlotte', 'Robinson', 57000.00);
Subscribe Now and Stay Updated! 🔔
► Visit our website: visionforanaly...
► Join our Facebook group: / 995887284773826