Introduction to SQL and Its History How to Answer SQL Interview Questions Relationships and Relational Database Concepts

Basic SQL Syntax The WHERE Clause Logical operators: AND, OR, NOT Finding similar results with LIKE and Wildcards Querying Missing Values with IS NULL and IS NOT NULL Sorting data with ORDER BY Using LIMIT and OFFSET IN and BETWEEN

Introduction to SQL Aggregations GROUP BY and HAVING Counting with COUNT and COUNT(DISTINCT)SUM Calculating Average, Min, and Max with SQL Conditional values with CASE WHEN ... ELSE Working with Date and Time: DATE_TRUNC, DATEDIFF, and more

Joins Inner Joins LEFT and RIGHT Joins Full Outer Joins Unions Cross Joins Subqueries and Derived tables Common Table Expressions (CTEs)

Introduction to Window Functions Window functions: RANK and DENSE RANK Window functions: ROW_NUMBER Window functions: LAG

Introduction to SQL Practice Questions Top Earning Employees

Monthly Post Success Analysis

High Volume Low Success

Marketing Campaign Duration

Find Average Purchase Value

Survey Sampling

Lyft Ride Requests

E-commerce: Units Ordered Yesterday

E-commerce: Units Ordered Last Week

E-commerce: Earliest Order by Customer

Total Transaction Volume

Top Salaries by Department

Employee Hierarchy

Post Success After Failure

Find Top Customer by Year

Find Monthly Revenue Growth

Initial Contact Attribution

Ranking Salary Deviations

Game Leaderboard

Amazon Order Status

Duolingo Leaderboards

Validate Bitcoin Transactions

E-commerce: Second Earliest Order

SQL Stored Procedures

Unlock full course

Introduction to SQL and Its History How to Answer SQL Interview Questions Relationships and Relational Database Concepts

Basic SQL Syntax The WHERE Clause Logical operators: AND, OR, NOT Finding similar results with LIKE and Wildcards Querying Missing Values with IS NULL and IS NOT NULL Sorting data with ORDER BY Using LIMIT and OFFSET IN and BETWEEN

Introduction to SQL Aggregations GROUP BY and HAVING Counting with COUNT and COUNT(DISTINCT)SUM Calculating Average, Min, and Max with SQL Conditional values with CASE WHEN ... ELSE Working with Date and Time: DATE_TRUNC, DATEDIFF, and more

Joins Inner Joins LEFT and RIGHT Joins Full Outer Joins Unions Cross Joins Subqueries and Derived tables Common Table Expressions (CTEs)

Introduction to Window Functions Window functions: RANK and DENSE RANK Window functions: ROW_NUMBER Window functions: LAG

Introduction to SQL Practice Questions Top Earning Employees

Monthly Post Success Analysis

High Volume Low Success

Marketing Campaign Duration

Find Average Purchase Value

Survey Sampling

Lyft Ride Requests

E-commerce: Units Ordered Yesterday

E-commerce: Units Ordered Last Week

E-commerce: Earliest Order by Customer

Total Transaction Volume

Top Salaries by Department

Employee Hierarchy

Post Success After Failure

Find Top Customer by Year

Find Monthly Revenue Growth

Initial Contact Attribution

Ranking Salary Deviations

Game Leaderboard

Amazon Order Status

Duolingo Leaderboards

Validate Bitcoin Transactions

E-commerce: Second Earliest Order

SQL Stored Procedures

Unlock full course

Courses SQL Interviews Window Functions

Window functions: ROW_NUMBER

Premium

In SQL, the ROW_NUMBER() function is a type of window function that assigns a unique number to each row in a result set, starting at 1 for the first row. This function is used to enumerate the rows in a query result and can be useful for pagination, filtering, and ranking results.

Basic syn...

Lesson contents

Join now to continue learning

As an Exponent member, you’ll get access to the rest of this course, and so much more.

Entire course library

Get full access to our course library, with hours of lessons and example answers.

Mock interview videos

Watch experts answer real interview questions in hundreds of videos.

Private Slack access

Join our daily discussions with 10,000 other Exponent members on Slack.

Live daily practice

With our new peer practice tool, you can practice with other members every day.

Not sure yet? Try the next free lesson