SQLCourse
Interactive Online SQL Training
HOME News MS SQL Oracle DB2 Access MySQL PHP SQL Etc Scripts Links Forums DBA Talk
SQL Courses
1What is SQL?
2Table basics
3Selecting data
4Creating tables
5Inserting into a table
6Updating records
7Deleting records
8Drop a table
9Advanced Queries
10Standalone SQL interpreter
11Advertise on SQLCourse.com
12Database Links
13Technology Jobs
Free Newsletters:
DatabaseDaily
 


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);
  1. Select all columns for everyone in your employee table.

    select * from
    myemployees_ts0211
  2. Select all columns for everyone with a salary over 30000.

    select * from
    myemployees_ts0211
    where salary > 30000
  3. Select first and last names for everyone that's under 30 years old.

    select firstname, lastname
    from myemployees_ts0211
    where age < 30
  4. 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%'
  5. Select all columns for everyone whose last name contains "ebe".

    select * from
    myemployees_ts0211
    where lastname LIKE '%ebe%'
  6. Select the first name for everyone whose first name equals "Potsy".

    select firstname from
    myemployees_ts0211
    where firstname = 'Potsy'
  7. Select all columns for everyone over 80 years old.

    select * from
    myemployees_ts0211
    where age > 80
  8. 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

 

SQL Course Curriculum
<<previous 123456789 next>>