Skip to main content

You are here

SQL Quiz 101 - SELECT Query

SQL is a powerful relational database programming language. Many IT professionals find it useful in their day to day activities including, DBAs, DB programmers, Software Testers etc. The SELECT statement retrieves rows of data from your database table. Within retrieved rows you may further narrow down which columns would appear. Conditions for filtering can be applied as well. The SELECT statement can be as simple or as complex as you want it to be (depending on your requirement). The simplest and most common use of this powerful statement could be as simple as: SELECT < field list > from < table name > Following is a simple SQL quiz that beginners may find interesting. Study the 3 tables above, answer the following questions.

tags: 

Category: 

Recent comments

Where did Ebola virus come from?

Are Africans the only ones who ate "dirty" meat?

2 years 12 months ago
Where did Ebola virus come from?

Ebola came from primates like apes. It got into humans via eating unsterile meat. Particularly in Africa where the practice of eating "bush meat"...2 years 12 months ago

What jobs need knowledge of computer programming?

You have mentioned mostly core coding related jobs. What about:

  1. Business Analyst
  2. Project manager (IT)
  3. Software...2 years 12 months ago

Popular Quizes Today

Premium Drupal Themes by Adaptivethemes