List of Topics

SfC Home > Web Design > SQL >

 

Mini-Quiz: Sorting Retrieved Column Data with SQL

by Ron Kurtus (revised 17 March 2016)

Take this Mini-Quiz to check your understanding of the lesson material.



1. Why can't you use the ORDER BY clause before other clauses?

Ordering is the last item to be done in retrieving data

You can use it before other clauses if you want them sorted

It depends on the size of the database

2. What order should you put the tables after the ORDER BY clause?

In the order you want the sorts to be performed

It does not really matter

It must be done alphanumerically

3. Can you mix ascending and descending sorts in a query?

No, because they would get things mixed up

Provided you used different tables

Yes, when you are sorting by multiple columns

If you got all three correct, you are on your way to becoming a Champion in Using SQL. If you had problems, you had better look over the material again.


Design carefully


Resources and references

Ron Kurtus' Credentials

Websites

SQL Resources

Books

Top-rated books on Using SQL


Questions and comments

Do you have any questions, comments, or opinions on this subject? If so, send an email with your feedback. I will try to get back to you as soon as possible.


Share this page

Click on a button to bookmark or share this page through Twitter, Facebook, email, or other services:

 

Students and researchers

The Web address of this page is:
www.school-for-champions.com/sql/
mini-quiz_sorting_data_in_columns.htm

Please include it as a link on your website or as a reference in your report, document, or thesis.

Copyright © Restrictions


Where are you now?

School for Champions

SQL topics

Mini-Quiz: Sorting Retrieved Column Data with SQL




SQL topics

Also see



Let's make the world a better place

Be the best that you can be.

Use your knowledge and skills to help others succeed.

Don't be wasteful; protect our environment.

You CAN influence the world.





Live Your Life as a Champion:

Take care of your health

Seek knowledge and gain skills

Do excellent work

Be valuable to others

Have utmost character

Be a Champion!


The School for Champions helps you become the type of person who can be called a Champion.