Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25426 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SQL: Select Statement

sql SQL: Select Statement SQL: Displaying data

If you want to return values from any SQL source you need to understand the most fundamental statement and if your reading this you have decided to take the first step towards understanding how databases tick!

The SQL Select Statement

The select statement by and large is quite easy to understand but bit by bit, line by line it can become a behemoth which can drive you potty.

The select statement has really two (possibly three) important commands:

  1. Select
    Informs it that you are going to perform an operation to display data.  After the select command you would then either place a “*” to indicate all fields or itemise the feilds you wish to display.
  2. From
    Tells it which table(s) you want to look at.  This can then expand into joining multiple tables which is discussed in a subsequent topic called joins.
  3. Where
    This is the optional clause which instructs it to filter the results, to understand this area better please refer to the where clause tutorial.

So a full example fo the SQL would be as follows:

Select
*
From Employees
Where
Lastname = ‘Flintstone’

This video is a gentle starting point to understand the basics of the select. Subsequent videos will build on this basic concept.

Other SQL Videos

This video is one of many SQL tutorials on this site click here for more

Related Posts

631 Comments

  1. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  2. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  3. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  4. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  5. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  6. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  7. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  8. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  9. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  10. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  11. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  12. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  13. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  14. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  15. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  16. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  17. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  18. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  19. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

  20. eagle003 says
    15 Dec 09 at 2:56pm

    This is brilliant, i don’t know why, but i understand my lessons more if i just watch 10 minutes of this then attending the classes for a few days..

1 2 3 32

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security