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.



Recent comments

Where did Ebola virus come from?

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

3 years 3 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"...3 years 3 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...3 years 3 months ago
Premium Drupal Themes by Adaptivethemes