Data manipulationPostgreSQL
SELECT
Retrieve rows with advanced filtering and window functions.
Command
SELECT * FROM WHERE status = 'active' ORDER BY created_at DESC LIMIT 50;
Example usage
Perform filtered selects or analytical window calculations.
SELECT * FROM <table> WHERE status = 'active' ORDER BY created_at DESC LIMIT 50;SELECT id, SUM(amount) OVER (PARTITION BY account_id) FROM <table>;Related tags
Data manipulationdatabasesqlpsql