In MySQL and most of other RDBMS - how to retrieve 100 records from Users table?
LIMIT keyword is used to retrieve not more than specified number of records from any given table.
SELECT some_fields 
FROM Users 
WHERE some_conditions
LIMIT number_of_records_to_return

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Sign Up Now
or Subscribe for future quizzes