List of Topics

SfC Home > Web Design > SQL >

 

Mini-Quiz: Filtering Data Retrieved from Database Table in SQL

by Ron Kurtus (5 February 2007)

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



1. Can you use WHERE when retrieving just one column?

Yes, but the data may not have much use except as a listing

It depends if you are using MySQL or Access databases

No, because you need several columns to use WHERE

2. Can the ">" operator be used with text fields?

Yes, it can be used with any type of data

As long as the text fields are not NULL

No, because "greater than" implies dealing with numbers

3. Why can't you use AND to filter two items from the same column?

You can if you have more than 10 rows in the column

You would end up with zero items listed

You can use as many AND operators as you want in filtering

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.


Weed things out


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_filtering_data.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: Filtering Data Retrieved from Database Table in 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.