Learn how to return specific rows from a query. Discover whether you can return partial results or return results a page at a time.
- [Narrator] You can use select with the where clause…to select rows from a table.…Start by selecting the world database,…and I'll type in a simple select statement.…And when I press go, you see we get 239 rows.…Now, what if I only want the rows…where the continent is Europe?…So I can say, "Where continent equals," and then,…in single quotes, the literal string "Europe."…And this'll look for rows where the continent column…matches the literal string that I typed here.…
And so, when I press go, now we only get…the countries in Europe, and I have only 46 rows returned.…Of course, I can still sort them.…I can say, "Order by name," and I still get 46 rows,…only now, they're in order by name,…and just in the continent of Europe.…It's important that "order by" is after the where clause.…The order of these clauses are actually significant in SQL.…
You can also limit the number of columns returned…with the limit clause.…I can say, "Limit five," and now, I only get five results.…The first five results.…If I want the second five results, I can say, "Offset five,"…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.