【例6.23】从样例数据库pubs的titles表中查询所有书籍，并按书名(title列)排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY title
运行结果：
title type
--------------------------------------------------------------------------------
But Is It User Friendly? popular_comp
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
Cooking with Computers,Surreptitious Balance Sheets business
Emotional Security,A New Algorithm psychology
Fifty Years in Buckingham Palace Kitchens trad_cook
Is Anger the Enemy? psychology
Life Without Fear psychology
Net Etiquette popular_comp
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Prolonged Data Deprivation,Four Case Studies psychology
Secrets of Silicon Valley popular_comp
Silicon Valley Gastronomic Treats mod_cook
Straight Talk About Computers business
Sushi,Anyone? trad_cook
The Busy Executive's Database Guide business
The Gourmet Microwave mod_cook
The Psychology of Computer Cooking UNDECIDED
You Can Combat Computer Stress! business
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并按书名的升序排序。缺省情况下，ORDER BY按升序排序，若要按降序排序，须使用DESC关键字。
【例6.24】从样例数据库pubs的titles表中查询所有书籍，并按书名(title列)的降序排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY title DESC
运行结果：
title type
-----------------------------------------------------------------------
You Can Combat Computer Stress! business
The Psychology of Computer Cooking UNDECIDED
The Gourmet Microwave mod_cook
The Busy Executive's Database Guide business
Sushi,Anyone? trad_cook
Straight Talk About Computers business
Silicon Valley Gastronomic Treats mod_cook
Secrets of Silicon Valley popular_comp
Prolonged Data Deprivation,Four Case Studies psychology
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Net Etiquette popular_comp
Life Without Fear psychology
Is Anger the Enemy? psychology
Fifty Years in Buckingham Palace Kitchens trad_cook
Emotional Security,A New Algorithm psychology
Cooking with Computers,Surreptitious Balance Sheets business
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
But Is It User Friendly? popular_comp
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并按书名的降序排序。
【例6.25】从样例数据库pubs的titles表中查询所有书籍，先按书籍的类型（type列）的升序排序，再按书名(title列)的降序排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY type,title DESC
运行结果：
title type
------------------------------------------------------------------------------
You Can Combat Computer Stress! business
The Busy Executive's Database Guide business
Straight Talk About Computers business
Cooking with Computers,Surreptitious Balance Sheets business
The Gourmet Microwave mod_cook
Silicon Valley Gastronomic Treats mod_cook
Secrets of Silicon Valley popular_comp
Net Etiquette popular_comp
But Is It User Friendly? popular_comp
Prolonged Data Deprivation,Four Case Studies psychology
Life Without Fear psychology
Is Anger the Enemy? psychology
Emotional Security,A New Algorithm psychology
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
Sushi,Anyone? trad_cook
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Fifty Years in Buckingham Palace Kitchens trad_cook
The Psychology of Computer Cooking UNDECIDED
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并先按书籍的类型（type列）的升序排序，然后再按书名(title列)的降序排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY title
运行结果：
title type
--------------------------------------------------------------------------------
But Is It User Friendly? popular_comp
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
Cooking with Computers,Surreptitious Balance Sheets business
Emotional Security,A New Algorithm psychology
Fifty Years in Buckingham Palace Kitchens trad_cook
Is Anger the Enemy? psychology
Life Without Fear psychology
Net Etiquette popular_comp
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Prolonged Data Deprivation,Four Case Studies psychology
Secrets of Silicon Valley popular_comp
Silicon Valley Gastronomic Treats mod_cook
Straight Talk About Computers business
Sushi,Anyone? trad_cook
The Busy Executive's Database Guide business
The Gourmet Microwave mod_cook
The Psychology of Computer Cooking UNDECIDED
You Can Combat Computer Stress! business
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并按书名的升序排序。缺省情况下，ORDER BY按升序排序，若要按降序排序，须使用DESC关键字。
【例6.24】从样例数据库pubs的titles表中查询所有书籍，并按书名(title列)的降序排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY title DESC
运行结果：
title type
-----------------------------------------------------------------------
You Can Combat Computer Stress! business
The Psychology of Computer Cooking UNDECIDED
The Gourmet Microwave mod_cook
The Busy Executive's Database Guide business
Sushi,Anyone? trad_cook
Straight Talk About Computers business
Silicon Valley Gastronomic Treats mod_cook
Secrets of Silicon Valley popular_comp
Prolonged Data Deprivation,Four Case Studies psychology
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Net Etiquette popular_comp
Life Without Fear psychology
Is Anger the Enemy? psychology
Fifty Years in Buckingham Palace Kitchens trad_cook
Emotional Security,A New Algorithm psychology
Cooking with Computers,Surreptitious Balance Sheets business
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
But Is It User Friendly? popular_comp
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并按书名的降序排序。
【例6.25】从样例数据库pubs的titles表中查询所有书籍，先按书籍的类型（type列）的升序排序，再按书名(title列)的降序排序。
USE pubs
SELECT title,type
FROM titles
ORDER BY type,title DESC
运行结果：
title type
------------------------------------------------------------------------------
You Can Combat Computer Stress! business
The Busy Executive's Database Guide business
Straight Talk About Computers business
Cooking with Computers,Surreptitious Balance Sheets business
The Gourmet Microwave mod_cook
Silicon Valley Gastronomic Treats mod_cook
Secrets of Silicon Valley popular_comp
Net Etiquette popular_comp
But Is It User Friendly? popular_comp
Prolonged Data Deprivation,Four Case Studies psychology
Life Without Fear psychology
Is Anger the Enemy? psychology
Emotional Security,A New Algorithm psychology
Computer Phobic AND Non-Phobic Individuals,Behavior Variations psychology
Sushi,Anyone? trad_cook
Onions,Leeks,and Garlic,Cooking Secrets of the Mediterranean trad_cook
Fifty Years in Buckingham Palace Kitchens trad_cook
The Psychology of Computer Cooking UNDECIDED
（所影响的行数为 18 行）
查询结果显示表titles中的所有书籍，并先按书籍的类型（type列）的升序排序，然后再按书名(title列)的降序排序。
