This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Using ORDER BY to Sort in SQL Server Queries Part two of a two-part series of blogs
If your SQL queries return lots of records you'll probably want to sort the results in some kind of order. This blog teaches you how to use the ORDER BY clause to do exactly that! Sorting in SQL Server Queries Finding the Top Records in a Query (this blog) This article is part of our complete SQL tutorial. You might also be interested in our SQL training courses.

Using ORDER BY to Sort in SQL Server Queries

Part two of a two-part series of blogs

If your SQL queries return lots of records you'll probably want to sort the results in some kind of order. This blog teaches you how to use the ORDER BY clause to do exactly that!

Sorting in SQL Server Queries
Finding the Top Records in a Query (this blog)

This article is part of our complete SQL tutorial. You might also be interested in our SQL training courses.

Posted by Andrew Gould on 23 July 2012

Finding the Top Records in a Query

You can use the TOP keyword in a SQL query to return a specified number of items from a table. You can use the ORDER BY clause to affect which items you will return.

The TOP Keyword

You can add the TOP keyword followed by a number immediately after the SELECT keyword in a query:

You can use any whole number after the word TOP to return that number of items.

Using Sorting to Change the Top Records

To make the TOP keyword more useful you can apply sorting to the results to change which records appear at the top of the list. The example below sorts the films in descending order of running time and then selects the top five films from the results:

This query shows the top five longest films.

To show the bottom records from the results, simply change the order of the sorting:

Here we've changed the order of the records so that the shortest films appear at the top of the list.

Including Tied Records

When you use the TOP keyword your query will return the number of records you have asked for, even if there are more records with a matching value in the sorted column. You can display these extra records by adding the WITH TIES keywords to your statement:

We only asked to see the TOP 5 records but because there was one more film with the same running time as the fifth we see that this is included in the results.

Showing the Top Records as a Percentage

Rather than asking to see a specific number of records you can ask to see a percentage of the total records returned by a query. To do this you just need to add the PERCENT keyword to your statement:

The table of films contains 260 records in total. When we ask for the TOP 10 PERCENT we return to top 26 records based on the sort order of the results.

When you use criteria in a query the PERCENT keyword returns a percentage of the records that are returned after the criteria have been applied.

Parts of this blog
Sorting in SQL Server Queries Finding the Top Records in a Query (this blog)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Finding the Top Records in a Query

The TOP Keyword

Using Sorting to Change the Top Records

Including Tied Records

Showing the Top Records as a Percentage

Head office

London

Manchester