SfC Home > Web Design > SQL >

Mini-Quiz: Retrieving Columns of Data with SQL

by Ron Kurtus (revised 17 March 2016)

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

---

---

1. What does the "wildcard" symbol mean?

It means you should show nothing

It means that all items are included

It has no real meaning and is used to fill in space

2. What do you SELECT to retrieve a single column?

The name of the column

A listing of all items in the column

The name of the database table

3. How do you retrieve several columns?

SELECT list of desired columns, separated by semi-colons (;)

You cannot retrieve several columns in SQL

SELECT list of desired columns, separated by commas

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.

---

Expand your expertise

---

Resources and references

Ron Kurtus' Credentials

Websites

SQL Resources

Books

(Notice: The School for Champions may earn commissions from book purchases)

Top-rated books on Using SQL

---

Students and researchers

The Web address of this page is:
www.school-for-champions.com/sql/
mini-quiz_retrieving_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: Retrieving Columns of Data with SQL

---

---

---

SQL topics

• Database Basics
• Retrieving Columns of Data
• Sorting Retrieved Column Data
• Filtering Data Retrieved
• Updating Data with SQL

Also see

• SQL Survey Results
• Website Development

---

---

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!