Search⌘ K
AI Features
Home
Courses
The Art of PostgreSQL

Solution Review: Top-N Factbook Entries

Explore how to construct SQL queries in PostgreSQL to retrieve and order Top-N factbook entries starting from a specific date. Understand the use of SELECT, WHERE, ORDER BY, and LIMIT clauses for effective data retrieval in a small application context.

We'll cover the following...

Solution

The solution for the challenge is given below. Click the “Run*” button in the following widget to see the output of the code.

PostgreSQL
/***************************************************/
/*****        The query here to retrieve       *****/
/*****   Top-N records from the factbook table *****/
/*****      starting from a specific date      *****/
/***************************************************/
\set start '2010-02-04'
\set n 10
  select date, shares, trades, dollars
    from factbook
   where date >= date :'start'
order by date
   limit :n;
/***************************************************/

Explanation

The explanation of the code is given below:

  • Line 6: First, we set the start
...