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
-
Question: The total power dissipation in an RL series circuit is due to which component? Answer: The total power dissipation is due to ...
-
//sample solution function additionWithoutCarrying(param1, param2) { var param1Array = param1.toString().split("").reverse()...
-
Type in the length of the shorter base of the trapezoid: meters Type in the length of the longer base of the trapezoid: meters ...
-
A regular polygon has sides of equal length. Type in the length of the side of a sided regular polygon: meters Compute
-
Type in the length of the side of a myriagon: meters Compute
-
Type in the length of the side of a dodecagon: meters Compute
-
#Sample Solution --- title: "Quantiles" output: html_notebook --- ```{r} # load song data load("songs.Rda") ```...
-
The spleen
-
This is the scrolling text . Code for the scrolling effect is written below: <style type="text/css"> #scro...
-
This script will try to solve for x in a system of linear equations of the form Ax=y . x is the unknown column vector and y is th...
No comments:
Post a Comment