How to Find the Top 5 Most Visited Pages on a Website in SQL
This query retrieves the top 5 most visited pages on a website based on page views.
SELECT
page_url,
COUNT(*) AS page_views
FROM
website_traffic
GROUP BY
page_url
ORDER BY
page_views DESC
LIMIT
5;
Use-case: A web analyst wants to identify the most popular pages to optimize for user engagement.
Ready to build Dashboards
and set Alerts?
This website uses cookies to ensure you get the best experience.