Sorting Result Sets

Loading...

來自 IBM 的課程

Databases and SQL for Data Science

20 個評分

IBM

Databases and SQL for Data Science

20 個評分

課程 4（共 4 門，Specialization Introduction to Data Science）

SQL is a powerful language which is used for communicating with databases. Before you step into the field of data science, it is vitally important that you set yourself apart by mastering the foundations of SQL. The purpose of this course is to introduce relational database concepts and help you learn and apply knowledge of the SQL language. Learners will also practice building and running SQL queries hands-on using a cloud-based environment as well as learn how to access databases from Jupyter notebooks using Python. If you choose to take this course and earn the Coursera course certificate, you will also earn an IBM digital badge upon successful completion of the course.

從本節課中

Week 2 - Advanced SQL

By the end of this module you will: (1) earn how to use string patterns and ranges to search data, how to sort and group data in result sets, as well as (2) learn how to work with multiple tables in a relational database using join operations.

Using String Patterns, Ranges4:22

Sorting Result Sets2:44

Grouping Result Sets3:32

與講師見面

Rav Ahuja
Data Science Program Manager
IBM Cognitive Class
Hima Vasudevan
Data Scientist
IBM Digital Business Group

Hello, and welcome to sorting SELECT statement results sets.

In this video, we will learn about some advanced techniques in retrieving data from

a relational database table and sorting how the result set displays.

At the end of this lesson,

you will be able to describe how to sort the result set by either ascending or

descending order and explain how to indicate which column to use for the sorting order.

The main purpose of a database management system is not just to store the data,

but also facilitate retrieval of the data.

In its simplest form,

a select statement is select * from table name.

Based on our simplified library database model, in the table book,

select * from book gives a result set of four rows.

All the data rows for all columns in the table book are displayed.

We can choose to list the book titles only as shown in this example,

select title from book.

However, the order does not seem to be in any order.

Displaying the results set in

alphabetical order would make the result set more convenient.

To do this, we use the "order by" clause.

To display the result set in alphabetical order,

we add the order by clause to the select statement.

The order by clause is used in a query to sort the result set by a specified column.

In this example, we have used order by on the column title to sort the result set.

By default, the result set is sorted in ascending order.

In this example, the result set is sorted in alphabetical order by book title.

To sort in descending order, use the key word" desc."

The result set is now sorted according to the column specified,

which is title, and is sorted in descending order.

Notice the order of the first three rows.

The first three words of the title are the same,

so the sorting starts from the point where the characters differ.

Another way of specifying the sort column is to indicate the column sequence number.

In this example, select title, pages from book,

order by two, indicates the column sequence number in the query for the sorting order.

Instead of specifying the column name pages,

the number two is used.

In the select statement, the second column specified in the column list is pages,

so the sort order is based on the values in the pages column.

In this case, the pages column indicates the number of pages in the book.

As you can see, the result set is in ascending order by number of pages.

Now you can describe how to sort the result set by either ascending or

descending order and explain how to indicate which column to use for the sorting order.

Thanks for watching this video.

探索我們的目錄

免費加入並獲得個性化推薦、更新和優惠。

Coursera 致力於普及全世界最好的教育，它與全球一流大學和機構合作提供在線課程。

© 2018 Coursera Inc. 保留所有權利。

通過 App Store 下載

通過 Google Play 獲取