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
-
<style> p { margin: 0px; padding-left: 10%; padding-right: 10%; text-align: justify; border-style: dashed;...
-
//sample solution var gender = "female"; if (gender === "female") { result = true; } else { result = false; ...
-
var AppointmentView = Backbone.View.extend({ render: function() { var html = '<li>' + this.model.get('title')...
-
import java.util.ArrayList; public class Temperatures { public static void main(String[] args) { ArrayList<Integer> weeklyTem...
-
//sample solution function candles(candlesNumber, makeNew) { var newCandles=candlesNumber; var newlyBurnedCandles=0; var lef...
-
#sample solution print bin(1) print bin(2) print bin(3) print bin(4) print bin(5)
-
Type in the length of the side of a hendecagon: meters Compute
-
<!DOCTYPE html> <html> <head> <title>Your own do-while</title> <link type='text/css...
-
#sample solution # boolean_1 = 77 < 78 && 77 < 77 boolean_1 = false # boolean_2 = true && 100 >= 100 boolea...
No comments:
Post a Comment