Inserting into a Table Answers
Your Insert statements should be similar to: (note: use your own table name that you created)
insert into
myemployees_ts0211
(firstname, lastname,
title, age, salary)
values ('Jonie', 'Weber',
'Secretary', 28,
19500.00);
-
Select all columns for everyone in your employee table.
select * from
myemployees_ts0211
-
Select all columns for everyone with a salary over 30000.
select * from
myemployees_ts0211
where salary > 30000
-
Select first and last names for everyone that's under 30 years old.
select firstname, lastname
from myemployees_ts0211
where age < 30
-
Select first name, last name, and salary for anyone with "Programmer" in their title.
select firstname, lastname, salary
from myemployees_ts0211
where title LIKE '%Programmer%'
-
Select all columns for everyone whose last name contains "ebe".
select * from
myemployees_ts0211
where lastname LIKE '%ebe%'
-
Select the first name for everyone whose first name equals "Potsy".
select firstname from
myemployees_ts0211
where firstname = 'Potsy'
-
Select all columns for everyone over 80 years old.
select * from
myemployees_ts0211
where age > 80
-
Select all columns for everyone whose last name ends in "ith".
select * from
myemployees_ts0211
where lastname LIKE '%ith'
Back to Inserting into a table