How We Teach How

My Classroom Classroom

Enroll by March 2nd, 2026

OUR PROGRAMS

FSWD, Data Science & Applied AI Full-stack Web Development Front-end Web Development Back-end Web Development Explore Our Programs Our Students Sample projects and assignments How We Teach FAQs Message Us

YOUR ACCOUNT

SwitchUp Ranked Best Coding Bootcamps 2025

How to COUNT all rows in SQL query while using LIMIT?

Altcademy Team wrote on 7 February 2018

You can use the OVER() clause in SQL. PostgreSQL has window functions counting rows before LIMIT is applied.

Example:

SELECT count(*) OVER() AS total_count
FROM table
WHERE condition
LIMIT 20

Learn web development online

Cohort 111 begins on March 2nd, 2026

Most Popular

Full-stack Web Development

Learn full-stack development with HTML, CSS, JavaScript, React, Ruby and Rails, Computer science fundamentals & programming skills.

VIEW DETAILS

Upgrade FSWD to include Python, Data Science, AI Application, TypeScript and more.

Front-end Web Development

Learn front-end development with HTML, CSS, JavaScript, and jQuery. Computer science fundamentals & programming skills.

VIEW DETAILS

Back-end Web Development

Learn back-end development with Ruby and Rails, M-V-C. Computer science fundamentals with practical programming skills.

VIEW DETAILS

Trusted by

Students and instructors from world-class organizations

Logos provided by Logo.dev

Join the upcoming Cohort #111

Enroll for March 2nd, 2026