External Exam Download Resources Web Applications Games Recycle Bin

Limits

limits1.sql

SELECT *
FROM menu
LIMIT 5

limits2.sql

SELECT title, price
FROM menu
ORDER BY price DESC
LIMIT 1

/* finds the most expensive item on the menu */
  1. show all the data for the first 3 items on the menu (ordered by num ASC)
  2. show title and calories for the highest 3 calorie items on the menu