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
-
#sample solution def colorful_conditions(): color = "blue" if color == "red": return "firs...
-
//Sample Solution const gameState = {} function preload() { this.load.image('codey', 'https://s3.amazonaws.com/codecademy-...
-
// sample solution to script.js $(document).ready(function() { $("ul.tabs li").click(function(){ var pageID = $(t...
-
//sample solution //Here is the original card object var card1 = {"suit":"clubs", "rank": 8}; //Create a ...
-
class Dog{ int age; public Dog(int dogsAge){ age = dogsAge; } public void bark() { System.out.println("Woof...
-
//sample solution // Here is the array we will store results in var multiples = []; function multiplesOf(base, i) { // Base case ...
-
function checkAnswerWrongPlace(ans, realanswer){ // This method compares two input strings representing a player's guess ("an...
-
Problem: The task is to minimize the value of the fraction x/f(x) where x is any 3-digit number and f(x) is its digits sum. What is the 3-d...
-
//sample solution function isCaseInsensitivePalindrome(inputString) { var temp = inputString.toLowerCase(); var tempReversed = te...
-
A regular polygon has sides of equal length. Type in the length of the side of a sided regular polygon: meters Compute
No comments:
Post a Comment