order-by – CodeRavo

Retrieving the Last N Rows in SQL Server

Introduction Frequently, when working with databases, you’ll need to retrieve only the most recent entries – … Retrieving the Last N Rows in SQL ServerRead more

database, last-n-rows, order-by, performance, queries, row-number, SQL Server, top, window-functions

Selecting Unique Rows with PostgreSQL's DISTINCT ON for Grouped Data

Introduction When working with SQL databases, particularly in applications that involve complex data aggregations or reporting, … Selecting Unique Rows with PostgreSQL's DISTINCT ON for Grouped DataRead more

distinct-on, group by, indexing, nulls-last, order-by, performance optimization, PostgreSQL, select, SQL