Free Newsletters:
DatabaseDaily
 

SQLCourse
Interactive Online SQL Training

Search Database Journal:

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



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>>