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.

24778 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. Faizal Adi says
    01 Nov 14 at 10:12am

    thanks for tutorial

  2. hohoyun says
    06 Jun 14 at 5:46pm

    nice tutorial

  3. Anu Chinjooz says
    12 Mar 14 at 3:21am
  4. RAJESH MALIK says
    12 Feb 13 at 7:36am

    very good tutorial….

  5. PCTeachME says
    14 Jul 11 at 4:00pm

    Thanks!

  6. PCTeachME says
    14 Jul 11 at 4:00pm

    [..YouTube..] Thanks!

  7. PCTeachME says
    14 Jul 11 at 4:00pm

    [..YouTube..] @nowthatsatattoo Thanks!

  8. PCTeachME says
    14 Jul 11 at 4:00pm

    @nowthatsatattoo Thanks!

  9. PCTeachME says
    14 Jul 11 at 4:00pm

    @nowthatsatattoo Thanks!

  10. PCTeachME says
    14 Jul 11 at 3:00pm

    @nowthatsatattoo Thanks!

  11. nowthatsatattoo says
    14 Jul 11 at 1:01am

    Beautiful! tnx a lot.

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security