Data operationsMySQL
SELECT
Query rows with filters, ordering, and limits.
Command
SELECT * FROM WHERE = '' ORDER BY created_at DESC LIMIT 20;
Example usage
Retrieve filtered results or aggregate metrics.
SELECT * FROM <table> WHERE <column> = '<value>' ORDER BY created_at DESC LIMIT 20;SELECT COUNT(*) FROM <table> WHERE status = 'active';Related tags
Data operationsdatabasesqlinnodb