Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

SQL: Learning the basics of the SELECT statement

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,589
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 18, 2010

This screencast will take you thought the in's and out's of the SQL SELECT statement, including using the FROM, WHERE and ORDER BY clauses. Additional topics such as the TOP and DISTINCT keywords, column aliasing with AS, and date/time functions are also covered

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (michaelfudge)

  • maybe i'm miscalculating it but @7:55 says 34 employees but @ 6:28 when you do top 20% of the employee's it gives you 7 employee's. so 7 * 5 (=20%) should be 35 employee's right? is this something SQL round's off? or am i missing something? tanx for youre video I hope it helps me with my exames today ^^

  • @stijnweegberg1983 yes. it rounds up to the nearest whole number 34 * 20% == 6.8 Rounded up to 7. I hope your prof didn't tests you on that, it's a rather obscure fact!

see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • Very good video thank you

  • Patty O'furniture, LOL. :)

  • Please keep doing your effort to save fortune to the thickest ppl like me :( your videos are great !!!

  • Thanks

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more