Problem: Enter these employees into your table Jonie Weber, Secretary, 28, 19500.00 Potsy Weber, Programmer, 32, 45300.00 Dirk Smith, Programmer II, 45, 75020.00 Solution: insert into employee (first, last, title, age, salary) values ('Jonie', 'Weber', 'Secretary', 28, 19500.00); insert into employee (first, last, title, age, salary) values ('Potsy', 'Weber', 'Programmer', 32, 45300.00); insert into employee (first, last, title, age, salary) values ('Dirk', 'Smith', 'Programmer II', 45, 75020.00);
Quotes help make search much faster. Example: "Practice Makes Perfect"
Wednesday, September 4, 2013
SQL Insert Problem
Problem: Enter these employees into your table Jonie Weber, Secretary, 28, 19500.00 Potsy Weber, Programmer, 32, 45300.00 Dirk Smith, Programmer II, 45, 75020.00 Solution: insert into employee (first, last, title, age, salary) values ('Jonie', 'Weber', 'Secretary', 28, 19500.00); insert into employee (first, last, title, age, salary) values ('Potsy', 'Weber', 'Programmer', 32, 45300.00); insert into employee (first, last, title, age, salary) values ('Dirk', 'Smith', 'Programmer II', 45, 75020.00);
Labels:
SQL
Subscribe to:
Post Comments (Atom)
This is an example of scrolling text using Javascript.
Popular Posts
-
A typical compounding problem would be something like: How much is the equivalent Present Value (P) if an investment pays an amount (A...
-
<style> span { background-image: url('http://hosturl.co.uk/cc/lady2.png'); width: 105px; heig...
-
// Sample solution // Write a string rotation method. // It should pass all the tests given below. String.prototype.rotate = function(n...
-
A typical compounding problem would be something like: How much will I get annually (A) starting next year if I invest a present value...
-
A typical compounding problem would be something like: What is the future value (F) of a present value (P) deposited/lent at an intere...
-
#sample solution class Shape(object): """Makes shapes!""" def __init__(self, number_of_sides): self....
-
A typical compounding problem would be something like: What is the present value (P) of a future value (F) if (P) was deposited/lent a...
-
The spleen
-
Say you had an election, and you needed to tally the votes for each candidate. All you need to do is enter the name of each candidate o...
-
#sample solution pyg = 'ay' original = raw_input('Enter a word:') if len(original) > 0 and original.isalpha(): p...
No comments:
Post a Comment