Back Home
  • Examples
  • Sample Database
#1 
SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit DESC LIMIT 5;
#2 
SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit LIMIT 5;
#3 
SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit, customerNumber LIMIT 5;
#4 
SELECT customerNumber, customerName FROM customers ORDER BY customerName LIMIT 10;
#5 
SELECT customerNumber, customerName FROM customers ORDER BY customerName LIMIT 10, 10;
#6 
SELECT customerName, creditLimit FROM customers ORDER BY creditLimit DESC LIMIT 1,1;
#7 
SELECT customerName, creditLimit FROM customers ORDER BY creditLimit DESC;
Table List
customers
SELECT * FROM customers;
employees
SELECT * FROM employees;
offices
SELECT * FROM offices;
orderdetails
SELECT * FROM orderdetails;
orders
SELECT * FROM orders;
payments
SELECT * FROM payments;
productlines
SELECT * FROM productlines;
products
SELECT * FROM products;
  • Result