CxD Archive
Code: Web App Data Visualization
Code: Web App Data Visualization
  • Getting Started
  • Dashboard Template Tutorial
    • 1 - First Look at Template
    • 2 - SQL Introduction
    • 3 - Producing Charts
    • 4 - Creating Your Own Database (Google Sheet)
  • SQL Examples
    • WHERE
    • LIKE
    • ORDER BY
    • LIMIT
  • Chart Examples
    • Bar Charts
    • Column Charts
    • Pie/Donut Chart
    • Histograms
    • Scatter Charts
    • Line Charts
    • Bubble Charts
    • Geo Charts
    • Geo Charts (Markers)
    • Tree Maps
  • Dashboard Layout Examples
    • Selectable Chart Data
    • Custom Grid 1
  • Viz Library Source (GitHub)
  • Google Charts Reference
  • Data Visualization Project Guide Book
  • Open Data Sources
Powered by GitBook
On this page
Export as PDF
  1. SQL Examples

LIMIT

Use "LIMIT" at the end to return only a defined number of rows from the top of the result. It is often used with "ORDER BY" like below.

SELECT Major, StartingMedianSalary FROM Degrees ORDER BY StartingMedianSalary DESC LIMIT 3

PreviousORDER BYNextChart Examples

Last updated 6 years ago