LIMIT - Restricting Results1 / 10
LIMIT limits the result to a certain number of records. To get the top 3 records of the creatures table, try:
SELECT * FROM creatures LIMIT 3;| creature_id | name | type | strength_level |
|---|---|---|---|
| 1 | Bigfoot | Cryptid | 85 |
| 2 | Loch Ness Monster | Cryptid | 90 |
| 3 | Chupacabra | Cryptid | 70 |
| 4 | Mothman | Cryptid | 65 |
| 5 | Jersey Devil | Cryptid | 75 |
| 6 | Yeti | Cryptid | 88 |
| 7 | Flatwoods Monster | Cryptid | 60 |
Ctrl+Enter to submit
LIMIT - Restricting Results - Free SQL Practice Online
Practise LIMIT - Restricting Results with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.