We have just learned how to display certain columns from a table. In this chapter, we’ll look at how to display certain rows from a table.
Why Restrict Data?
In our earlier examples, we looked at all columns in a table and one or two columns from a table. One of the queries looked like this:
SELECT id, last_name, salary
FROM employee;
This query will show the id, last_name, and salary columns for all employees in the table. What if you didn’t want to see all employees in the table? In our example table, there are five records. But what if the table had one hundred, or one ...
